APPS.PAY_SG_CPFLINE dependencies on PAY_PAYROLL_ACTIONS

Line 11: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

7: -- the archive process knows what code to execute for each step of
8: -- the archive.
9: --------------------------------------------------------------------
10: procedure range_code
11: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
12: p_sql out nocopy varchar2);
13: --
14: procedure assignment_action_code
15: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 15: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

11: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
12: p_sql out nocopy varchar2);
13: --
14: procedure assignment_action_code
15: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
16: p_start_person_id in per_all_people_f.person_id%type,
17: p_end_person_id in per_all_people_f.person_id%type,
18: p_chunk in number );
19: --

Line 21: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);

17: p_end_person_id in per_all_people_f.person_id%type,
18: p_chunk in number );
19: --
20: procedure initialization_code
21: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
22: --
23: procedure archive_code
24: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
25: p_effective_date in date);

Line 28: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) ;

24: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
25: p_effective_date in date);
26: --
27: procedure deinit_code
28: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) ;
29: --
30: --------------------------------------------------------------------------
31: -- company_identification cursor
32: -- Bug#3501950 - Added CPF_Interest and FWL_Interest parameters

Line 154: from pay_payroll_actions ppa,

150: 'EMPLOYEE_NUMBER=P',
151: pai.action_information18||'#'||pai.action_information18 employee_number,
152: 'EMP_TERMINATION_DATE=P',
153: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
154: from pay_payroll_actions ppa,
155: pay_assignment_actions paa,
156: pay_action_information pai
157: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
158: and ppa.payroll_action_id = paa.payroll_action_id

Line 342: from pay_payroll_actions ppa,

338: pai.action_information19,
339: ppa.payroll_action_id,
340: pai.action_information21
341: ) emp_termination_date
342: from pay_payroll_actions ppa,
343: pay_assignment_actions paa,
344: pay_action_information pai
345: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
346: and ppa.payroll_action_id = paa.payroll_action_id

Line 410: from pay_payroll_actions ppa,

406: 'EMPLOYEE_NUMBER=P',
407: pai.action_information18||'#'||pai.action_information18 employee_number,
408: 'EMP_TERMINATION_DATE=P',
409: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
410: from pay_payroll_actions ppa,
411: pay_assignment_actions paa,
412: pay_action_information pai
413: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
414: and ppa.payroll_action_id = paa.payroll_action_id

Line 598: from pay_payroll_actions ppa,

594: pai.action_information19,
595: ppa.payroll_action_id,
596: pai.action_information21
597: ) emp_termination_date
598: from pay_payroll_actions ppa,
599: pay_assignment_actions paa,
600: pay_action_information pai
601: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
602: and ppa.payroll_action_id = paa.payroll_action_id

Line 635: from pay_payroll_actions ppa,

631: 'CDAC Fund', pai.action_information10,
632: 'ECF Fund', pai.action_information11,
633: 'FWL', pai.action_information16,
634: 'SHARE Program Donations', pai.action_information14)) value
635: from pay_payroll_actions ppa,
636: pay_assignment_actions paa,
637: pay_action_information pai,
638: hr_lookups hl
639: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')