APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_ACTION_INFORMATION

Line 248: pay_action_information_api.create_action_information (

244: g_legal_employer_name := l_legal_employer_rec.legal_employer_name;
245: g_legal_employer_org_no := l_legal_employer_rec.legal_employer_org_no;
246: --
247: --
248: pay_action_information_api.create_action_information (
249: p_action_information_id => l_action_info_id,
250: p_action_context_id => p_payroll_action_id,
251: p_action_context_type => 'PA',
252: p_object_version_number => l_ovn,

Line 266: pay_action_information_api.create_action_information (

262: --
263: --
264: for i in csr_all_local_unit_details (g_legal_employer_id)
265: loop
266: pay_action_information_api.create_action_information (
267: p_action_information_id => l_action_info_id,
268: p_action_context_id => p_payroll_action_id,
269: p_action_context_type => 'PA',
270: p_object_version_number => l_ovn,

Line 2125: pay_action_information_api.create_action_information (

2121:
2122: /* End loop for for cnt in 1 .. l_detailed_output.count*/
2123:
2124:
2125: pay_action_information_api.create_action_information (
2126: p_action_information_id => l_action_info_id,
2127: p_action_context_id => l_assact_id,
2128: p_action_context_type => 'AAP',
2129: p_object_version_number => l_ovn,

Line 2301: from pay_action_information pai

2297: action_information6 local_unit_id,
2298: action_information7
2299: local_unit_name,
2300: action_information8 local_unit_org_no, effective_date
2301: from pay_action_information pai
2302: where action_context_type = 'PA'
2303: and action_context_id = p_payroll_action_id
2304: and action_information_category = 'EMEA REPORT INFORMATION'
2305: and action_information1 = 'PYNOEERSTC';

Line 2339: pay_action_information pai

2335: fnd_date.canonical_to_date (action_information20)
2336: action_information20
2337: from pay_payroll_actions paa,
2338: pay_assignment_actions assg,
2339: pay_action_information pai
2340: where paa.payroll_action_id = p_payroll_action_id
2341: and assg.payroll_action_id = paa.payroll_action_id
2342: and pai.action_context_id = assg.assignment_action_id
2343: and pai.action_context_type = 'AAP'

Line 2359: pay_action_information pai

2355: ) is
2356: select count (*)
2357: from pay_payroll_actions paa,
2358: pay_assignment_actions assg,
2359: pay_action_information pai
2360: where paa.payroll_action_id = p_payroll_action_id
2361: and assg.payroll_action_id = paa.payroll_action_id
2362: and pai.action_context_id = assg.assignment_action_id
2363: and pai.action_context_type = 'AAP'