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_HK_IR56_MAGTAPE dependencies on PAY_CORE_UTILS

Line 77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

73: pay_payroll_actions ppa,
74: pay_payroll_actions ppa2,
75: pay_payroll_actions ppa3
76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
78: and fue.user_entity_id = fai.user_entity_id
79: and fue.user_entity_name like 'X_HK_IR56_%_ASG_LE_YTD'
80: and fai.context1 = paa.assignment_action_id
81: and paa.payroll_action_id = ppa3.payroll_action_id

Line 83: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)

79: and fue.user_entity_name like 'X_HK_IR56_%_ASG_LE_YTD'
80: and fai.context1 = paa.assignment_action_id
81: and paa.payroll_action_id = ppa3.payroll_action_id
82: and paa.action_status = 'C'
83: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
84: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null
85: group by paa.assignment_id
86: ) archive_count,
87: (

Line 94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

90: pay_payroll_actions ppa2,
91: pay_assignment_actions paa,
92: pay_payroll_actions ppa3--archive action
93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
95: and ppa3.payroll_action_id = paa.payroll_action_id
96: and paa.action_status = 'C'
97: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
98:

Line 97: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)

93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
95: and ppa3.payroll_action_id = paa.payroll_action_id
96: and paa.action_status = 'C'
97: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
98:
99: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null
100: and rownum=1
101: ) assign_action

Line 130: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,
128: per_people_f pap
129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
131: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
132: and pac.action_status = 'C'
133: and ppa3.payroll_action_id = pac.payroll_action_id
134: and paa.assignment_id = pac.assignment_id

Line 131: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)

127: pay_assignment_actions pac3,
128: per_people_f pap
129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
131: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
132: and pac.action_status = 'C'
133: and ppa3.payroll_action_id = pac.payroll_action_id
134: and paa.assignment_id = pac.assignment_id
135: and pac3.payroll_action_id = ppa3.payroll_action_id

Line 140: where pap1.person_id = pap.person_id and to_date('31-03'||pay_core_utils.get_parameter('REPORTING_YEAR',

136: and paa.assignment_id = pac3.assignment_id
137: and pap.person_id = paa.person_id
138: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', pac3.assignment_action_id) is null
139: and pap.effective_start_date = (select max(pap1.effective_start_date) from per_people_f pap1
140: where pap1.person_id = pap.person_id and to_date('31-03'||pay_core_utils.get_parameter('REPORTING_YEAR',
141: ppa3.legislative_parameters),'DD-MM-YYYY') between pap1.effective_start_date and pap1.effective_end_date)
142: /* Start for bug 2690005 */
143: /* Added to eliminate terminated employees */
144: and pay_hk_ir56_report.get_archive_value('X_HK_LAST_NAME', pac3.assignment_action_id) is not null