APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 722: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

718: IS
719:
720:
721: lc_object_version_number NUMBER;
722: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
723: TYPE r_assignment_rec IS RECORD
724: (assignment_id per_all_assignments_f.assignment_id%TYPE,
725: allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE
726: ,user_type VARCHAR2(10));

Line 724: (assignment_id per_all_assignments_f.assignment_id%TYPE,

720:
721: lc_object_version_number NUMBER;
722: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
723: TYPE r_assignment_rec IS RECORD
724: (assignment_id per_all_assignments_f.assignment_id%TYPE,
725: allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE
726: ,user_type VARCHAR2(10));
727:
728: TYPE t_assignment_tab IS TABLE OF r_assignment_rec

Line 789: l_new_assignment_id per_all_assignments_f.assignment_id%TYPE;

785: l_get_alloc_info c_get_alloc_info%ROWTYPE;
786: l_count NUMBER :=0;
787: l_assignment_present VARCHAR2(1) :=NULL;
788: l_assignment_add VARCHAr2(1) :=NULL;
789: l_new_assignment_id per_all_assignments_f.assignment_id%TYPE;
790: l_correction NUMBER;
791: l_update NUMBER;
792: l_update_override NUMBER;
793: l_update_change_insert NUMBER;

Line 1230: FROM per_all_assignments_f paa

1226: ,cp_effective_date DATE
1227: )
1228: IS
1229: SELECT paa.assignment_id
1230: FROM per_all_assignments_f paa
1231: WHERE paa.person_id = cp_person_id
1232: AND paa.primary_flag ='Y'
1233: AND paa.business_group_id = cp_business_group_id
1234: AND cp_effective_date BETWEEN paa.effective_start_date

Line 1245: FROM per_all_assignments_f paa

1241: ,cp_effective_date DATE
1242: )
1243: IS
1244: SELECT paa.assignment_id
1245: FROM per_all_assignments_f paa
1246: WHERE paa.person_id = cp_person_id
1247: AND paa.assignment_id <> cp_assignment_id
1248: AND paa.business_group_id = cp_business_group_id
1249: AND cp_effective_date BETWEEN paa.effective_start_date

Line 1281: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1277: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
1278: l_get_repository_id c_get_repository_id%ROWTYPE;
1279: l_lookup_code hr_lookups.lookup_code%TYPE;
1280: l_leg_code pqp_configuration_values.legislation_code%TYPE;
1281: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1282: l_correction NUMBER;
1283: l_update NUMBER;
1284: l_update_override NUMBER;
1285: l_update_change_insert NUMBER;

Line 3423: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3419: l_error_status VARCHAR2(10);
3420: l_effective_start_date DATE;
3421: l_effective_end_date DATE;
3422: l_person_id per_all_people_f.person_id%TYPE;
3423: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3424: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3425: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3426: l_effective_date DATE;
3427: BEGIN

Line 3424: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3420: l_effective_start_date DATE;
3421: l_effective_end_date DATE;
3422: l_person_id per_all_people_f.person_id%TYPE;
3423: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3424: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3425: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3426: l_effective_date DATE;
3427: BEGIN
3428: l_person_id := hr_transaction_api.get_number_value (