APPS.PQP_INI_BAL dependencies on PER_ASSIGNMENTS_F

Line 1265: ,per_assignments_f ASS

1261: ,pay_payroll_actions BACT
1262: ,per_time_periods BPTP
1263: ,per_time_periods PPTP
1264: ,pay_assignment_actions BAL_ASSACT
1265: ,per_assignments_f ASS
1266: ,per_assignments_f START_ASS
1267: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
1268: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1269: AND FEED.balance_type_id = cp_balance_type_id

Line 1266: ,per_assignments_f START_ASS

1262: ,per_time_periods BPTP
1263: ,per_time_periods PPTP
1264: ,pay_assignment_actions BAL_ASSACT
1265: ,per_assignments_f ASS
1266: ,per_assignments_f START_ASS
1267: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
1268: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1269: AND FEED.balance_type_id = cp_balance_type_id
1270: AND FEED.input_value_id = TARGET.input_value_id

Line 1294: FROM per_assignments_f NASS

1290: /* that had a different tax district at that date */
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

Line 1297: ,per_assignments_f PASS

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
1301: AND ROLL.payroll_id = NASS.payroll_id