APPS.PAY_ZA_EMP201 dependencies on PAY_ACTION_INFORMATION

Line 369: pay_action_information_api.create_action_information

365: -- Convert calendar month to 'Mon YYYY' format, for eg 'Feb 2008'
366: l_payroll_prd := to_char(to_date(l_calendar_month,'RRRR/MM/DD HH24:MI:SS'),'Mon YYYY');
367:
368: -- Archive 'ZA EMP201 LEGAL ENTITY DETAILS'
369: pay_action_information_api.create_action_information
370: (
371: p_action_information_id => l_action_info_id,
372: p_action_context_id => p_payroll_action_id,
373: p_action_context_type => 'PA',

Line 1389: pay_action_information_api.create_action_information

1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);
1386:
1387:
1388: -- Archive the ZA EMP201 ASSIGNMENT DETAILS
1389: pay_action_information_api.create_action_information
1390: (
1391: p_action_information_id => l_action_info_id,
1392: p_action_context_id => p_assactid, -- Assignment Action of the Archiver
1393: p_action_context_type => 'AAP',

Line 1441: , pay_action_information pai

1437: ppf.payroll_name payroll_name,
1438: pai.effective_date effective_date
1439: from pay_payroll_actions ppa
1440: , pay_assignment_actions paa
1441: , pay_action_information pai
1442: , pay_all_payrolls_f ppf
1443: where ppa.payroll_action_id = pactid
1444: and ppa.action_status = 'C'
1445: and paa.payroll_action_id = ppa.payroll_action_id

Line 1468: pay_action_information_api.create_action_information

1464: loop
1465: hr_utility.set_location(l_proc, 20);
1466:
1467: -- Archive 'ZA EMP201 PAYROLL DETAILS'
1468: pay_action_information_api.create_action_information
1469: (
1470: p_action_information_id => l_action_info_id,
1471: p_action_context_id => pactid,
1472: p_action_context_type => 'PA',

Line 1595: from pay_action_information

1591: cursor csr_get_emp201_le_data(p_archive_pact number) is
1592: select action_information1 l_legal_entity_id
1593: , action_information2 l_legal_entity_name
1594: , action_information3 l_payroll_prd
1595: from pay_action_information
1596: where action_context_id = p_archive_pact
1597: and action_context_type = 'PA'
1598: and action_information_category = 'ZA EMP201 LEGAL ENTITY DETAILS' ;
1599:

Line 1603: from pay_action_information

1599:
1600: cursor csr_get_emp201_payroll_data(p_archive_pact number) is
1601: select action_information1 payroll_id
1602: , action_information2 payroll_name
1603: from pay_action_information
1604: where action_context_id = p_archive_pact
1605: and action_context_type = 'PA'
1606: and action_information_category = 'ZA EMP201 PAYROLL DETAILS'
1607: order by payroll_id ;

Line 1626: from pay_action_information pai

1622: action_information13 cnt_paye_non_perm,
1623: action_information14 raise_warning,
1624: action_information15 asg_terminated,
1625: action_information16 assignment_no
1626: from pay_action_information pai
1627: , pay_assignment_actions paa
1628: where paa.payroll_action_id = p_archive_pact
1629: and pai.action_context_id = paa.assignment_action_id
1630: and pai.action_context_type = 'AAP'