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_FPS_NI_AND_OTHERS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2234: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,

2230: -1,-1,0)),'DD-MM-YYYY'))
2231:
2232: and PPTP.regular_payment_date >= /* Termination check for RTI NI Reporting assignment. */
2233: ( nvl(
2234: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,
2235: per_assignment_extra_info PX
2236: where paa1.assignment_id = BAL_ASSACT.assignment_id
2237: and paa1.person_id = paa2.person_id
2238: and PX.assignment_id = paa2.assignment_id

Line 3207: per_all_assignments_f paaf,

3203: IS
3204: SELECT paaf.business_group_id,
3205: flex.segment1
3206: FROM pay_assignment_actions paa,
3207: per_all_assignments_f paaf,
3208: hr_soft_coding_keyflex flex,
3209: pay_payrolls_f ppf,
3210: pay_payroll_actions ppa
3211: WHERE ppa.payroll_action_id = L_PAYROLL_ACTION_ID

Line 3388: per_all_assignments_f paaf,

3384: pay_external_accounts Orgkey,
3385: pay_external_accounts deskey,
3386: PAY_ASSIGNMENT_ACTIONS PAA,
3387: PER_ALL_PEOPLE_F PAPF,
3388: per_all_assignments_f paaf,
3389: pay_payroll_actions ppa
3390: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
3391: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
3392: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID