APPS.PQP_INI_BAL dependencies on PAY_PAYROLL_ACTIONS

Line 870: ,pay_payroll_actions ppa

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
874: AND ppa.business_group_id= cp_business_group_id

Line 887: FROM pay_payroll_actions ppa

883: ,cp_business_group_id NUMBER
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

Line 1022: l_consol_set_id pay_payroll_actions.consolidation_set_id%TYPE;

1018: AND p_effective_date BETWEEN piv.effective_start_date
1019: AND piv.effective_end_date
1020: ORDER BY piv.display_sequence;
1021:
1022: l_consol_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1023: --l_base_ele_det c_base_ele_lnk_det%ROWTYPE;
1024: l_get_input_val_id c_get_input_val_id%ROWTYPE;
1025: l_count number:=0;
1026: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1259: ,pay_payroll_actions PACT

1255: from
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

Line 1261: ,pay_payroll_actions BACT

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
1265: ,per_assignments_f ASS

Line 1423: , pay_payroll_actions PACT

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
1427: AND TARGET.run_result_id = RR.run_result_id

Line 1525: ,pay_payroll_actions ppa

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
1528: AND petei.information_type='PQP_VEHICLE_MILEAGE_INFO'
1529: AND petei.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'