eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_CPFLINE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 24: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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);
26: --
27: procedure deinit_code
28: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) ;

Line 155: pay_assignment_actions paa,

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
159: and paa.assignment_action_id = pai.action_context_id

Line 165: pay_assignment_actions paa_dup

161: and pai.action_context_type = 'AAC'
162: and pai.action_information2 = 'EE'
163: and not exists ( select 1
164: from pay_action_information pai_dup,
165: pay_assignment_actions paa_dup
166: where pai.action_information_category = pai_dup.action_information_category
167: and pai.rowid <> pai_dup.rowid
168: and paa_dup.payroll_action_id = ppa.payroll_action_id
169: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 343: pay_assignment_actions paa,

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
347: and paa.assignment_action_id = pai.action_context_id

Line 353: pay_assignment_actions paa_dup

349: and pai.action_context_type = 'AAC'
350: and pai.action_information2 = 'EE'
351: and exists ( select 1
352: from pay_action_information pai_dup,
353: pay_assignment_actions paa_dup
354: where pai.action_information_category = pai_dup.action_information_category
355: and pai.rowid <> pai_dup.rowid
356: and paa_dup.payroll_action_id = ppa.payroll_action_id
357: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 411: pay_assignment_actions paa,

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
415: and paa.assignment_action_id = pai.action_context_id

Line 421: pay_assignment_actions paa_dup

417: and pai.action_context_type = 'AAC'
418: and pai.action_information2 = 'NEW'
419: and not exists ( select 1
420: from pay_action_information pai_dup,
421: pay_assignment_actions paa_dup
422: where pai.action_information_category = pai_dup.action_information_category
423: and pai.rowid <> pai_dup.rowid
424: and paa_dup.payroll_action_id = ppa.payroll_action_id
425: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 599: pay_assignment_actions paa,

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
603: and paa.assignment_action_id = pai.action_context_id

Line 609: pay_assignment_actions paa_dup

605: and pai.action_context_type = 'AAC'
606: and pai.action_information2 = 'NEW'
607: and exists ( select 1
608: from pay_action_information pai_dup,
609: pay_assignment_actions paa_dup
610: where pai.action_information_category = pai_dup.action_information_category
611: and pai.rowid <> pai_dup.rowid
612: and paa_dup.payroll_action_id = ppa.payroll_action_id
613: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 636: pay_assignment_actions paa,

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')
640: and ppa.payroll_action_id = paa.payroll_action_id