DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_ACTION_INFORMATION

Line 244: pay_action_information_api.create_action_information (

240: g_legal_employer_name := l_legal_employer_rec.legal_employer_name;
241: g_legal_employer_org_no := l_legal_employer_rec.legal_employer_org_no;
242: --
243: --
244: pay_action_information_api.create_action_information (
245: p_action_information_id => l_action_info_id,
246: p_action_context_id => p_payroll_action_id,
247: p_action_context_type => 'PA',
248: p_object_version_number => l_ovn,

Line 262: pay_action_information_api.create_action_information (

258: --
259: --
260: for i in csr_all_local_unit_details (g_legal_employer_id)
261: loop
262: pay_action_information_api.create_action_information (
263: p_action_information_id => l_action_info_id,
264: p_action_context_id => p_payroll_action_id,
265: p_action_context_type => 'PA',
266: p_object_version_number => l_ovn,

Line 1948: pay_action_information_api.create_action_information (

1944:
1945: /* End loop for for cnt in 1 .. l_detailed_output.count*/
1946:
1947:
1948: pay_action_information_api.create_action_information (
1949: p_action_information_id => l_action_info_id,
1950: p_action_context_id => l_assact_id,
1951: p_action_context_type => 'AAP',
1952: p_object_version_number => l_ovn,

Line 2124: from pay_action_information pai

2120: action_information6 local_unit_id,
2121: action_information7
2122: local_unit_name,
2123: action_information8 local_unit_org_no, effective_date
2124: from pay_action_information pai
2125: where action_context_type = 'PA'
2126: and action_context_id = p_payroll_action_id
2127: and action_information_category = 'EMEA REPORT INFORMATION'
2128: and action_information1 = 'PYNOEERSTC';

Line 2162: pay_action_information pai

2158: fnd_date.canonical_to_date (action_information20)
2159: action_information20
2160: from pay_payroll_actions paa,
2161: pay_assignment_actions assg,
2162: pay_action_information pai
2163: where paa.payroll_action_id = p_payroll_action_id
2164: and assg.payroll_action_id = paa.payroll_action_id
2165: and pai.action_context_id = assg.assignment_action_id
2166: and pai.action_context_type = 'AAP'

Line 2182: pay_action_information pai

2178: ) is
2179: select count (*)
2180: from pay_payroll_actions paa,
2181: pay_assignment_actions assg,
2182: pay_action_information pai
2183: where paa.payroll_action_id = p_payroll_action_id
2184: and assg.payroll_action_id = paa.payroll_action_id
2185: and pai.action_context_id = assg.assignment_action_id
2186: and pai.action_context_type = 'AAP'