APPS.PSP_PAYTRN dependencies on PSP_CLEARING_ACCOUNT

Line 366: FROM psp_clearing_account

362: l_subline_sum NUMBER := 0; -- Corrected to NUMBER from NUMBER(22, 2) for bug fix 2916848
363:
364: CURSOR get_clearing_account_csr is
365: SELECT reversing_gl_ccid
366: FROM psp_clearing_account
367: where set_of_books_id=l_resp_set_of_books_id
368: and business_group_id=l_resp_business_group_id
369: and payroll_id = l_payroll_id; -- Added for bug 5592964
370:

Line 761: -- Verify clearing account in psp_clearing_accounts

757: */
758:
759: -- End of bug fix 2916848
760:
761: -- Verify clearing account in psp_clearing_accounts
762: -- if not found or is 0 exit with error.
763:
764: open get_clearing_account_csr;
765: fetch get_clearing_account_csr into l_clearing_account;