APPS.PQP_INI_BAL dependencies on PAY_PAYROLLS_F

Line 1295: ,pay_payrolls_f ROLL

1291: (SELECT nvl(max(NASS.effective_start_date),
1292: to_date('01/01/0001', 'DD/MM/YYYY'))
1293:
1294: FROM per_assignments_f NASS
1295: ,pay_payrolls_f ROLL
1296: ,hr_soft_coding_keyflex FLEX
1297: ,per_assignments_f PASS
1298: ,pay_payrolls_f PROLL
1299: ,hr_soft_coding_keyflex PFLEX

Line 1298: ,pay_payrolls_f PROLL

1294: FROM per_assignments_f NASS
1295: ,pay_payrolls_f ROLL
1296: ,hr_soft_coding_keyflex FLEX
1297: ,per_assignments_f PASS
1298: ,pay_payrolls_f PROLL
1299: ,hr_soft_coding_keyflex PFLEX
1300: WHERE NASS.assignment_id = ASS.assignment_id
1301: AND ROLL.payroll_id = NASS.payroll_id
1302: AND NASS.effective_start_date BETWEEN

Line 1318: FROM pay_payrolls_f BROLL

1314: AND FLEX.segment1 <> PFLEX.segment1 )
1315: AND EXISTS
1316: /* check that the current assignment tax districts match */
1317: (SELECT NULL
1318: FROM pay_payrolls_f BROLL
1319: ,hr_soft_coding_keyflex BFLEX
1320: ,pay_payrolls_f PROLL
1321:
1322: ,hr_soft_coding_keyflex PFLEX

Line 1320: ,pay_payrolls_f PROLL

1316: /* check that the current assignment tax districts match */
1317: (SELECT NULL
1318: FROM pay_payrolls_f BROLL
1319: ,hr_soft_coding_keyflex BFLEX
1320: ,pay_payrolls_f PROLL
1321:
1322: ,hr_soft_coding_keyflex PFLEX
1323: WHERE BACT.payroll_id = BROLL.payroll_id
1324: AND PACT.payroll_id = PROLL.payroll_id