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_ACTION_INFORMATION

Line 156: pay_action_information pai

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
160: and pai.action_information_category = 'SG CPF DETAILS'

Line 164: from pay_action_information pai_dup,

160: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 344: pay_action_information pai

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
348: and pai.action_information_category = 'SG CPF DETAILS'

Line 352: from pay_action_information pai_dup,

348: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 412: pay_action_information pai

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
416: and pai.action_information_category = 'SG CPF DETAILS'

Line 420: from pay_action_information pai_dup,

416: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 600: pay_action_information pai

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
604: and pai.action_information_category = 'SG CPF DETAILS'

Line 608: from pay_action_information pai_dup,

604: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 637: pay_action_information pai,

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