APPS.PSP_PI_IMPORT_DATA dependencies on PAY_PAYROLLS_F

Line 611: from PAY_PAYROLLS_F a

607: END;
608:
609: select Cost_Allocation_KeyFlex_ID
610: into n_Cost_Allocation_KeyFlex_ID
611: from PAY_PAYROLLS_F a
612: where a.PAYROLL_ID = n_Payroll_ID
613: and d_Effective_Date BETWEEN a.EFFECTIVE_START_DATE AND a.EFFECTIVE_END_DATE
614: and a.business_group_id = v_business_group_id;
615:

Line 624: -- Next, obtain the Set_Of_Books_ID from Pay_Payrolls_F

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');
628: v_Set_Of_Books_ID := FND_Profile.Value('PSP_SET_OF_BOOKS');

Line 632: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot

628: v_Set_Of_Books_ID := FND_Profile.Value('PSP_SET_OF_BOOKS');
629:
630: If (v_Set_Of_Books_ID IS NULL) or (to_number(v_Set_Of_Books_ID) <> n_Set_Of_Books_ID) Then
631: -- dbms_output.put_line('Profile value for Set of Books ID :' ||
632: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot
633: -- proceed');
634: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');
635: fnd_msg_pub.add;
636: return 2;

Line 676: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot

672: -- v_Set_Of_Books_ID := FND_Profile.Value('PSP_SET_OF_BOOKS');
673:
674: If (v_Set_Of_Books_ID IS NULL) Then
675: -- dbms_output.put_line('Profile value for Set of Books ID :' ||
676: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot
677: -- proceed');
678: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');
679: fnd_msg_pub.add;
680: return 2;