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_GB_EDI_P46_CAR dependencies on PAY_ASSIGNMENT_ACTIONS

Line 106: FROM pay_assignment_actions act_edi,

102: 'NI_NO=P', max(action_information5),
103: 'POSTAL_CODE=P', ' ', -- bug 5169434 not to output post code
104: 'TITLE=P', nvl(max(action_information4), ' '),
105: 'TOWN_OR_CITY=P', nvl(max(action_information9), ' ')
106: FROM pay_assignment_actions act_edi,
107: ----------------------------------------------------------
108: -- Commented out following joins to fix performance issue
109: -- raised in bug 3374673.
110: -- pay_action_interlocks pail,

Line 111: -- pay_assignment_actions act,

107: ----------------------------------------------------------
108: -- Commented out following joins to fix performance issue
109: -- raised in bug 3374673.
110: -- pay_action_interlocks pail,
111: -- pay_assignment_actions act,
112: ----------------------------------------------------------
113: -- Bug 4059844 - SQL Repository Perf
114: -- pay_payroll_actions pact,
115: pay_action_information pai

Line 150: FROM pay_assignment_actions act_edi,

146: 'CO2_EMISSIONS_FIGURE=P', action_information11,
147: 'FUEL_FOR_PRIVATE_USE_FLAG=P', action_information12,
148: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
149: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
150: FROM pay_assignment_actions act_edi,
151: per_all_assignments_f asg,
152: pay_action_information pai
153: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
154: ('TRANSFER_PAYROLL_ACTION_ID')

Line 225: FROM pay_assignment_actions act_edi,

221: 'TITLE=P', nvl(max(action_information4), ' '),
222: 'TOWN_OR_CITY=P', nvl(max(action_information9), ' '),
223: 'DOB=P', nvl(max(ACTION_INFORMATION12),' '),
224: 'GENDER=P',nvl(max(ACTION_INFORMATION13), ' ')
225: FROM pay_assignment_actions act_edi,
226: ----------------------------------------------------------
227: -- Commented out following joins to fix performance issue
228: -- raised in bug 3374673.
229: -- pay_action_interlocks pail,

Line 230: -- pay_assignment_actions act,

226: ----------------------------------------------------------
227: -- Commented out following joins to fix performance issue
228: -- raised in bug 3374673.
229: -- pay_action_interlocks pail,
230: -- pay_assignment_actions act,
231: ----------------------------------------------------------
232: -- Bug 4059844 - SQL Repository Perf
233: -- pay_payroll_actions pact,
234: pay_action_information pai

Line 269: FROM pay_assignment_actions act_edi,

265: 'CO2_EMISSIONS_FIGURE=P', action_information11,
266: 'FUEL_FOR_PRIVATE_USE_FLAG=P', action_information12,
267: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
268: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
269: FROM pay_assignment_actions act_edi,
270: per_all_assignments_f asg,
271: pay_action_information pai
272: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
273: ('TRANSFER_PAYROLL_ACTION_ID')