DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_ACTION_INFORMATION

Line 274: pay_action_information_api.create_action_information (

270: g_legal_employer_name := l_legal_employer_rec.legal_employer_name;
271: g_legal_employer_org_no := l_legal_employer_rec.legal_employer_org_no;
272: --
273: --
274: pay_action_information_api.create_action_information (
275: p_action_information_id => l_action_info_id,
276: p_action_context_id => p_payroll_action_id,
277: p_action_context_type => 'PA',
278: p_object_version_number => l_ovn,

Line 292: pay_action_information_api.create_action_information (

288: );
289:
290: for i in csr_all_local_unit_details (g_legal_employer_id)
291: loop
292: pay_action_information_api.create_action_information (
293: p_action_information_id => l_action_info_id,
294: p_action_context_id => p_payroll_action_id,
295: p_action_context_type => 'PA',
296: p_object_version_number => l_ovn,

Line 1347: pay_action_information_api.create_action_information (

1343: p_payroll_action_id,
1344: 20, --P_chunk,
1345: null );
1346:
1347: pay_action_information_api.create_action_information (
1348: p_action_information_id => l_action_info_id,
1349: p_action_context_id => l_assact_id,
1350: p_action_context_type => 'AAP',
1351: p_object_version_number => l_ovn,

Line 1499: pay_action_information_api.create_action_information (

1495: p_payroll_action_id,
1496: 20, --P_chunk,
1497: null );
1498:
1499: pay_action_information_api.create_action_information (
1500: p_action_information_id => l_action_info_id,
1501: p_action_context_id => l_assact_id,
1502: p_action_context_type => 'AAP',
1503: p_object_version_number => l_ovn,

Line 1784: pay_action_information_api.create_action_information (

1780: and collemptable (1).job_id is not null
1781: and collemptable (1).job_id <> '0'
1782: )
1783: or (cnt <> 1) then
1784: pay_action_information_api.create_action_information (
1785: p_action_information_id => l_action_info_id,
1786: p_action_context_id => l_assact_id,
1787: p_action_context_type => 'AAP',
1788: p_object_version_number => l_ovn,

Line 2853: pay_action_information_api.create_action_information (

2849: and collemptable (1).job_id is not null
2850: and collemptable (1).job_id <> '0'
2851: )
2852: or (cnt <> 1) then
2853: pay_action_information_api.create_action_information (
2854: p_action_information_id => l_action_info_id,
2855: p_action_context_id => l_assact_id,
2856: p_action_context_type => 'AAP',
2857: p_object_version_number => l_ovn,

Line 3171: from pay_action_information pai

3167: action_information6 local_unit_id,
3168: action_information7
3169: local_unit_name,
3170: action_information8 local_unit_org_no, effective_date
3171: from pay_action_information pai
3172: where action_context_type = 'PA'
3173: and action_context_id = p_payroll_action_id
3174: and action_information_category = 'EMEA REPORT INFORMATION'
3175: and action_information1 = 'PYNOEERCNT';

Line 3205: pay_action_information pai

3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23
3203: from pay_payroll_actions paa,
3204: pay_assignment_actions assg,
3205: pay_action_information pai
3206: where paa.payroll_action_id = p_payroll_action_id
3207: and assg.payroll_action_id = paa.payroll_action_id
3208: and pai.action_context_id = assg.assignment_action_id
3209: and pai.action_context_type = 'AAP'

Line 3225: pay_action_information pai

3221: ) is
3222: select count(*)
3223: from pay_payroll_actions paa,
3224: pay_assignment_actions assg,
3225: pay_action_information pai
3226: where paa.payroll_action_id = p_payroll_action_id
3227: and assg.payroll_action_id = paa.payroll_action_id
3228: and pai.action_context_id = assg.assignment_action_id
3229: and pai.action_context_type = 'AAP'