APPS.PQP_INI_BAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 1296: ,hr_soft_coding_keyflex FLEX

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
1300: WHERE NASS.assignment_id = ASS.assignment_id

Line 1299: ,hr_soft_coding_keyflex PFLEX

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
1303: ROLL.effective_start_date AND ROLL.effective_end_date

Line 1319: ,hr_soft_coding_keyflex BFLEX

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
1323: WHERE BACT.payroll_id = BROLL.payroll_id

Line 1322: ,hr_soft_coding_keyflex PFLEX

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
1325: AND BFLEX.soft_coding_keyflex_id = BROLL.soft_coding_keyflex_id
1326: AND PFLEX.soft_coding_keyflex_id = PROLL.soft_coding_keyflex_id