Need Table Storing Bank's "Active" Flag from Personal payment Methods Screen
Hello,
I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Self-Service). Specifically, I want to determine which bank accounts or personal payment methods are currently active or inactive.
If there's no direct "Active" flag stored in the database, I would appreciate any suggestions on how to identify inactive bank accounts or payment methods, possibly via end dates, status codes, or related flags across tables like PAY_PERSONAL_PAYMENT_METHODS_F, CE_BANK_ACCOUNTS etc.
Any guidance, including table/column names or sample queries, would be greatly appreciated.