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 130: FROM pay_assignment_actions act_edi,

126: 'TITLE=P', nvl(max(action_information4), ' '),
127: 'TOWN_OR_CITY=P', nvl(max(action_information9), ' '),
128: 'DOB=P', nvl(max(ACTION_INFORMATION12),' '),
129: 'GENDER=P',nvl(max(ACTION_INFORMATION13), ' ')
130: FROM pay_assignment_actions act_edi,
131: ----------------------------------------------------------
132: -- Commented out following joins to fix performance issue
133: -- raised in bug 3374673.
134: -- pay_action_interlocks pail,

Line 135: -- pay_assignment_actions act,

131: ----------------------------------------------------------
132: -- Commented out following joins to fix performance issue
133: -- raised in bug 3374673.
134: -- pay_action_interlocks pail,
135: -- pay_assignment_actions act,
136: ----------------------------------------------------------
137: -- Bug 4059844 - SQL Repository Perf
138: -- pay_payroll_actions pact,
139: pay_action_information pai

Line 216: FROM pay_assignment_actions act_edi,

212: 'FUEL_FOR_PRIVATE_USE_FLAG=P', action_information12,
213: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
214: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
215: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
216: FROM pay_assignment_actions act_edi,
217: per_all_assignments_f asg,
218: pay_action_information pai
219: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')

Line 248: FROM pay_assignment_actions act_edi,

244: 'TITLE=P', nvl(max(action_information4), ' '),
245: 'TOWN_OR_CITY=P', nvl(max(action_information9), ' '),
246: 'DOB=P', nvl(max(ACTION_INFORMATION12),' '),
247: 'GENDER=P',nvl(max(ACTION_INFORMATION13), ' ')
248: FROM pay_assignment_actions act_edi,
249: ----------------------------------------------------------
250: -- Commented out following joins to fix performance issue
251: -- raised in bug 3374673.
252: -- pay_action_interlocks pail,

Line 253: -- pay_assignment_actions act,

249: ----------------------------------------------------------
250: -- Commented out following joins to fix performance issue
251: -- raised in bug 3374673.
252: -- pay_action_interlocks pail,
253: -- pay_assignment_actions act,
254: ----------------------------------------------------------
255: -- Bug 4059844 - SQL Repository Perf
256: -- pay_payroll_actions pact,
257: pay_action_information pai

Line 375: FROM pay_assignment_actions act_edi,

371: 'FUEL_FOR_PRIVATE_USE_FLAG=P', action_information12,
372: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
373: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
374: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
375: FROM pay_assignment_actions act_edi,
376: per_all_assignments_f asg,
377: pay_action_information pai
378: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')

Line 407: FROM pay_assignment_actions act_edi,

403: 'TITLE=P', nvl(max(action_information4), ' '),
404: 'TOWN_OR_CITY=P', nvl(max(action_information9), ' '),
405: 'DOB=P', nvl(max(ACTION_INFORMATION12),' '),
406: 'GENDER=P',nvl(max(ACTION_INFORMATION13), ' ')
407: FROM pay_assignment_actions act_edi,
408: ----------------------------------------------------------
409: -- Commented out following joins to fix performance issue
410: -- raised in bug 3374673.
411: -- pay_action_interlocks pail,

Line 412: -- pay_assignment_actions act,

408: ----------------------------------------------------------
409: -- Commented out following joins to fix performance issue
410: -- raised in bug 3374673.
411: -- pay_action_interlocks pail,
412: -- pay_assignment_actions act,
413: ----------------------------------------------------------
414: -- Bug 4059844 - SQL Repository Perf
415: -- pay_payroll_actions pact,
416: pay_action_information pai

Line 448: FROM pay_assignment_actions act_edi,

444: 'FUEL_FOR_PRIVATE_USE_FLAG=P', action_information12,
445: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
446: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
447: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
448: FROM pay_assignment_actions act_edi,
449: per_all_assignments_f asg,
450: pay_action_information pai
451: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
452: ('TRANSFER_PAYROLL_ACTION_ID')