DBA Data[Home] [Help]

APPS.PSP_PAYTRN dependencies on PSP_CLEARING_ACCOUNT

Line 368: FROM psp_clearing_account

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

Line 763: -- Verify clearing account in psp_clearing_accounts

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