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 165: pay_assignment_actions paa,

161: pai.action_information18||'#'||pai.action_information18 employee_number,
162: 'EMP_TERMINATION_DATE=P',
163: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
164: from pay_payroll_actions ppa,
165: pay_assignment_actions paa,
166: pay_action_information pai
167: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: and ppa.payroll_action_id = paa.payroll_action_id
169: and paa.assignment_action_id = pai.action_context_id

Line 183: pay_assignment_actions paa_dup

179: or
180: pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
181: and not exists ( select 1
182: from pay_action_information pai_dup,
183: pay_assignment_actions paa_dup
184: where pai.action_information_category = pai_dup.action_information_category
185: and pai.rowid <> pai_dup.rowid
186: and paa_dup.payroll_action_id = ppa.payroll_action_id
187: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 361: pay_assignment_actions paa,

357: ppa.payroll_action_id,
358: pai.action_information21
359: ) emp_termination_date
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa,
362: pay_action_information pai
363: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
364: and ppa.payroll_action_id = paa.payroll_action_id
365: and paa.assignment_action_id = pai.action_context_id

Line 378: pay_assignment_actions paa_dup

374: or to_number(pai.action_information6)<>0)))
375: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
376: and exists ( select 1
377: from pay_action_information pai_dup,
378: pay_assignment_actions paa_dup
379: where pai.action_information_category = pai_dup.action_information_category
380: and pai.rowid <> pai_dup.rowid
381: and paa_dup.payroll_action_id = ppa.payroll_action_id
382: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 436: pay_assignment_actions paa,

432: pai.action_information18||'#'||pai.action_information18 employee_number,
433: 'EMP_TERMINATION_DATE=P',
434: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
435: from pay_payroll_actions ppa,
436: pay_assignment_actions paa,
437: pay_action_information pai
438: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
439: and ppa.payroll_action_id = paa.payroll_action_id
440: and paa.assignment_action_id = pai.action_context_id

Line 453: pay_assignment_actions paa_dup

449: or to_number(pai.action_information6)<>0)))
450: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
451: and not exists ( select 1
452: from pay_action_information pai_dup,
453: pay_assignment_actions paa_dup
454: where pai.action_information_category = pai_dup.action_information_category
455: and pai.rowid <> pai_dup.rowid
456: and paa_dup.payroll_action_id = ppa.payroll_action_id
457: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 631: pay_assignment_actions paa,

627: ppa.payroll_action_id,
628: pai.action_information21
629: ) emp_termination_date
630: from pay_payroll_actions ppa,
631: pay_assignment_actions paa,
632: pay_action_information pai
633: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
634: and ppa.payroll_action_id = paa.payroll_action_id
635: and paa.assignment_action_id = pai.action_context_id

Line 648: pay_assignment_actions paa_dup

644: or to_number(pai.action_information6)<>0)))
645: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
646: and exists ( select 1
647: from pay_action_information pai_dup,
648: pay_assignment_actions paa_dup
649: where pai.action_information_category = pai_dup.action_information_category
650: and pai.rowid <> pai_dup.rowid
651: and paa_dup.payroll_action_id = ppa.payroll_action_id
652: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 675: pay_assignment_actions paa,

671: 'ECF Fund', pai.action_information11,
672: 'FWL', pai.action_information16,
673: 'SHARE Program Donations', pai.action_information14)) value
674: from pay_payroll_actions ppa,
675: pay_assignment_actions paa,
676: pay_action_information pai,
677: hr_lookups hl
678: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
679: and ppa.payroll_action_id = paa.payroll_action_id