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 PAY_PAYROLLS_F

Line 2243: INDEX(NROLL PAY_PAYROLLS_F_PK)

2239: /* find the latest td payroll transfer date - compare each of the */
2240: /* assignment rows with its predecessor looking for the payroll */
2241: /* that had a different tax district at that date */
2242: ( select /*+ ordered use_nl(ASS PASS NROLL FLEX PROLL PFLEX)
2243: INDEX(NROLL PAY_PAYROLLS_F_PK)
2244: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2245: nvl(max(ASS.effective_start_date),
2246: to_date('01/01/0001','DD/MM/YYYY'))
2247: from per_assignments_f ASS

Line 2244: INDEX(PROLL PAY_PAYROLLS_F_PK) */

2240: /* assignment rows with its predecessor looking for the payroll */
2241: /* that had a different tax district at that date */
2242: ( select /*+ ordered use_nl(ASS PASS NROLL FLEX PROLL PFLEX)
2243: INDEX(NROLL PAY_PAYROLLS_F_PK)
2244: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2245: nvl(max(ASS.effective_start_date),
2246: to_date('01/01/0001','DD/MM/YYYY'))
2247: from per_assignments_f ASS
2248: ,per_assignments_f PASS /* previous assignment */

Line 2249: ,pay_payrolls_f NROLL

2245: nvl(max(ASS.effective_start_date),
2246: to_date('01/01/0001','DD/MM/YYYY'))
2247: from per_assignments_f ASS
2248: ,per_assignments_f PASS /* previous assignment */
2249: ,pay_payrolls_f NROLL
2250: ,hr_soft_coding_keyflex FLEX
2251: ,pay_payrolls_f PROLL
2252: ,hr_soft_coding_keyflex PFLEX
2253: where ASS.assignment_id = BAL_ASSACT.assignment_id

Line 2251: ,pay_payrolls_f PROLL

2247: from per_assignments_f ASS
2248: ,per_assignments_f PASS /* previous assignment */
2249: ,pay_payrolls_f NROLL
2250: ,hr_soft_coding_keyflex FLEX
2251: ,pay_payrolls_f PROLL
2252: ,hr_soft_coding_keyflex PFLEX
2253: where ASS.assignment_id = BAL_ASSACT.assignment_id
2254: and NROLL.payroll_id = ASS.payroll_id
2255: and ASS.effective_start_date between

Line 3204: pay_payrolls_f ppf,

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
3207: AND paa.payroll_action_id = ppa.payroll_action_id
3208: AND paaf.assignment_id = paa.assignment_id