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

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

2218: -1,-1,0)),'DD-MM-YYYY'))
2219:
2220: and PPTP.regular_payment_date >= /* Termination check for RTI NI Reporting assignment. */
2221: ( nvl(
2222: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,
2223: per_assignment_extra_info PX
2224: where paa1.assignment_id = BAL_ASSACT.assignment_id
2225: and paa1.person_id = paa2.person_id
2226: and PX.assignment_id = paa2.assignment_id

Line 3202: per_all_assignments_f paaf,

3198: IS
3199: SELECT paaf.business_group_id,
3200: flex.segment1
3201: FROM pay_assignment_actions paa,
3202: per_all_assignments_f paaf,
3203: hr_soft_coding_keyflex flex,
3204: pay_payrolls_f ppf,
3205: pay_payroll_actions ppa
3206: WHERE ppa.payroll_action_id = L_PAYROLL_ACTION_ID

Line 3383: per_all_assignments_f paaf,

3379: pay_external_accounts Orgkey,
3380: pay_external_accounts deskey,
3381: PAY_ASSIGNMENT_ACTIONS PAA,
3382: PER_ALL_PEOPLE_F PAPF,
3383: per_all_assignments_f paaf,
3384: pay_payroll_actions ppa
3385: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
3386: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
3387: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID