APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 251: FROM per_all_assignments_f paaf

247: ,cp_effective_date DATE
248: )
249: IS
250: SELECT payroll_id
251: FROM per_all_assignments_f paaf
252: WHERE paaf.assignment_id=cp_assignment_id
253: AND cp_effective_date BETWEEN paaf.effective_start_date
254: AND paaf.effective_end_date
255: AND paaf.business_group_id =cp_business_group_id

Line 519: per_all_assignments_f asgt ,

515: ,link.element_link_id
516: FROM pay_element_types_f_tl elementtl,
517: pay_element_types_f element,
518: pay_element_links_f link,
519: per_all_assignments_f asgt ,
520: pay_element_type_extra_info pete,
521: per_periods_of_service service_period
522: WHERE element.element_type_id = elementtl.element_type_id
523: AND elementtl.language = USERENV('LANG')

Line 641: per_all_assignments_f asgt ,

637: SELECT element.element_type_id , elementtl.element_name
638: FROM pay_element_types_f_tl elementtl,
639: pay_element_types_f element,
640: pay_element_links_f link,
641: per_all_assignments_f asgt ,
642: pay_element_type_extra_info pete,
643: per_periods_of_service service_period
644: WHERE element.element_type_id = elementtl.element_type_id
645: AND elementtl.language = USERENV('LANG')

Line 869: l_get_pay_det per_all_assignments_f.payroll_id%TYPE;

865:
866:
867: --Variables
868: l_proc varchar2(72) := g_package ||'insert_mileage_claim';
869: l_get_pay_det per_all_assignments_f.payroll_id%TYPE;
870: --l_get_payroll_det c_get_payroll_det%ROWTYPE;
871: --l_get_alt_payroll_det c_get_alt_payroll_det%ROWTYPE;
872: l_get_asg_element_id pay_element_types_f.element_type_id%TYPE;
873: l_get_purp_element_id pay_element_types_f.element_type_id%TYPE;

Line 1872: ,per_all_assignments_f paa

1868: CURSOR c_chk_alloc (cp_registration_number VARCHAR2)
1869: IS
1870: SELECT 'Start_Valid' valid_date
1871: FROM pqp_vehicle_allocations_f pva
1872: ,per_all_assignments_f paa
1873: ,pqp_vehicle_repository_f pvr
1874: WHERE pva.assignment_id=p_assignment_id
1875: AND pvr.registration_number=cp_registration_number
1876: AND pvr.vehicle_repository_id=pva.vehicle_repository_id

Line 1890: ,per_all_assignments_f paa

1886: AND pvr.effective_end_date
1887: UNION
1888: SELECT 'End_Valid' valid_date
1889: FROM pqp_vehicle_allocations_f pva
1890: ,per_all_assignments_f paa
1891: ,pqp_vehicle_repository_f pvr
1892: WHERE pva.assignment_id=p_assignment_id
1893: AND pvr.registration_number=cp_registration_number
1894: AND pvr.vehicle_repository_id=pva.vehicle_repository_id