APPS.PQP_INI_BAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 869: FROM pay_assignment_actions paa

865: ,cp_max_date DATE)
866: IS
867: SELECT ppa.payroll_id
868: ,ppa.consolidation_set_id
869: FROM pay_assignment_actions paa
870: ,pay_payroll_actions ppa
871: WHERE paa.assignment_id= cp_assignment_id
872: AND ppa.payroll_action_id=paa.payroll_action_id
873: AND ppa.effective_date = cp_max_date

Line 888: ,pay_assignment_actions paa

884: )
885: IS
886: SELECT max(ppa.effective_date) effective_date
887: FROM pay_payroll_actions ppa
888: ,pay_assignment_actions paa
889: WHERE paa.assignment_id= cp_assignment_id
890: AND ppa.payroll_action_id=paa.payroll_action_id
891: AND ppa.business_group_id= cp_business_group_id
892: AND ppa.action_type in ('R','Q')

Line 1245: from pay_assignment_actions

1241:
1242: CURSOR c_assignment_action_id
1243: IS
1244: select max(assignment_action_id)
1245: from pay_assignment_actions
1246: where assignment_id = p_assignment_id;
1247:
1248: l_assignment_action_id NUMBER;
1249:

Line 1260: ,pay_assignment_actions ASSACT

1256: pay_balance_feeds_f FEED
1257: ,pay_run_result_values TARGET
1258: ,pay_run_results RR
1259: ,pay_payroll_actions PACT
1260: ,pay_assignment_actions ASSACT
1261: ,pay_payroll_actions BACT
1262: ,per_time_periods BPTP
1263: ,per_time_periods PPTP
1264: ,pay_assignment_actions BAL_ASSACT

Line 1264: ,pay_assignment_actions BAL_ASSACT

1260: ,pay_assignment_actions ASSACT
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

Line 1421: , pay_assignment_actions ASSACT

1417: * FEED.scale),0) tot
1418: FROM pay_run_result_values TARGET
1419: , pay_balance_feeds_f FEED
1420: , pay_run_results RR
1421: , pay_assignment_actions ASSACT
1422: , pay_assignment_actions BAL_ASSACT
1423: , pay_payroll_actions PACT
1424: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
1425: AND FEED.balance_type_id = cp_balance_type_id

Line 1422: , pay_assignment_actions BAL_ASSACT

1418: FROM pay_run_result_values TARGET
1419: , pay_balance_feeds_f FEED
1420: , pay_run_results RR
1421: , pay_assignment_actions ASSACT
1422: , pay_assignment_actions BAL_ASSACT
1423: , pay_payroll_actions PACT
1424: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
1425: AND FEED.balance_type_id = cp_balance_type_id
1426: AND FEED.input_value_id = TARGET.input_value_id

Line 1523: ,pay_assignment_actions paa

1519: ,to_number(NULL) Claimed_Mileage
1520: ,to_number(NULL) Actual_Mileage
1521: From pay_element_types_f pet
1522: ,pay_element_type_extra_info petei
1523: ,pay_assignment_actions paa
1524: ,pay_run_results prr
1525: ,pay_payroll_actions ppa
1526: WHERE pet.business_group_id = p_business_group_id
1527: AND pet.element_type_id=petei.element_type_id