APPS.PAY_DK_PR_ELE dependencies on PAY_ACTION_INFORMATION

Line 187: from pay_action_information

183:
184: --cursor to check current archive exists
185: cursor csr_count is
186: select count(*)
187: from pay_action_information
188: where action_information_category = 'EMEA REPORT DETAILS'
189: and action_information1 = 'PYDKPRELEA'
190: and action_context_id = pactid;
191:

Line 518: pay_action_information_api.create_action_information (

514: END;
515:
516: -- Archive the REPORT DETAILS(input Parameters)
517:
518: pay_action_information_api.create_action_information (
519: p_action_information_id => l_action_info_id -- out parameter
520: ,p_object_version_number => l_ovn -- out parameter
521: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
522: ,p_action_context_type => 'PA' -- context type

Line 552: pay_action_information_api.create_action_information (

548: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
549: CLOSE csr_pr_ele_ytd;
550:
551: -- Creating Archive Entries
552: pay_action_information_api.create_action_information (
553:
554: p_action_information_id => l_action_info_id -- out parameter
555: ,p_object_version_number => l_ovn -- out parameter
556: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)

Line 590: pay_action_information_api.create_action_information (

586: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
587: CLOSE csr_pr_ele_ytd;
588:
589: -- Creating Archive Entries
590: pay_action_information_api.create_action_information (
591:
592: p_action_information_id => l_action_info_id -- out parameter
593: ,p_object_version_number => l_ovn -- out parameter
594: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)

Line 713: pay_action_information pai1,

709: ,fnd_number.canonical_to_number(pai2.action_information9) pay_value
710: ,fnd_number.canonical_to_number(pai2.action_information10) balance_amount
711:
712: FROM
713: pay_action_information pai1,
714: pay_action_information pai2
715: WHERE
716:
717: -- Removing to_char for bug fix 5231458

Line 714: pay_action_information pai2

710: ,fnd_number.canonical_to_number(pai2.action_information10) balance_amount
711:
712: FROM
713: pay_action_information pai1,
714: pay_action_information pai2
715: WHERE
716:
717: -- Removing to_char for bug fix 5231458
718: --TO_CHAR(pai1.action_context_id)=l_payroll_action_id