DBA Data[Home] [Help]

APPS.PSP_PI_IMPORT_DATA dependencies on PSP_CLEARING_ACCOUNT

Line 623: -- procedure below. Instead, we want to obtain GL_CCID from PSP_Clearing_Account (Venkat 06/24)

619: from DUAL;
620:
621: /*********************************************************************************************
622: -- Commented out the following code bcos we no longer want to obtain GL_CCID from the complex
623: -- procedure below. Instead, we want to obtain GL_CCID from PSP_Clearing_Account (Venkat 06/24)
624: -- Next, obtain the Set_Of_Books_ID from Pay_Payrolls_F
625: -- Obtain Cost Allocation Key Flex ID, GL_Code_Combination_ID, and
626: -- Balance_Amount using Venkat's procedure
627: -- dbms_output.put_line('Running Venkat''s procedure for GL CCID');

Line 653: from PSP_CLEARING_ACCOUNT a

649: ******************************************************************************************/
650: Begin
651: Select reversing_gl_ccid
652: into n_GL_Code_Combination_ID
653: from PSP_CLEARING_ACCOUNT a
654: where a.business_group_id = v_business_group_id
655: and a.set_of_books_id = v_set_of_books_id
656: and a.payroll_id = n_payroll_id; -- Added for bug 5592964
657: