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 PAY_PAYROLLS_F

Line 2255: INDEX(NROLL PAY_PAYROLLS_F_PK)

2251: /* find the latest td payroll transfer date - compare each of the */
2252: /* assignment rows with its predecessor looking for the payroll */
2253: /* that had a different tax district at that date */
2254: ( select /*+ ordered use_nl(ASS PASS NROLL FLEX PROLL PFLEX)
2255: INDEX(NROLL PAY_PAYROLLS_F_PK)
2256: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2257: nvl(max(ASS.effective_start_date),
2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS

Line 2256: INDEX(PROLL PAY_PAYROLLS_F_PK) */

2252: /* assignment rows with its predecessor looking for the payroll */
2253: /* that had a different tax district at that date */
2254: ( select /*+ ordered use_nl(ASS PASS NROLL FLEX PROLL PFLEX)
2255: INDEX(NROLL PAY_PAYROLLS_F_PK)
2256: INDEX(PROLL PAY_PAYROLLS_F_PK) */
2257: nvl(max(ASS.effective_start_date),
2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */

Line 2261: ,pay_payrolls_f NROLL

2257: nvl(max(ASS.effective_start_date),
2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2264: ,hr_soft_coding_keyflex PFLEX
2265: where ASS.assignment_id = BAL_ASSACT.assignment_id

Line 2263: ,pay_payrolls_f PROLL

2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2264: ,hr_soft_coding_keyflex PFLEX
2265: where ASS.assignment_id = BAL_ASSACT.assignment_id
2266: and NROLL.payroll_id = ASS.payroll_id
2267: and ASS.effective_start_date between

Line 3209: pay_payrolls_f ppf,

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