APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 518: pay_element_links_f link,

514: , elementtl.element_name
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

Line 640: pay_element_links_f link,

636: IS
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

Line 860: FROM pay_element_links_f pelf

856: ,cp_business_group_id NUMBER
857: )
858: IS
859: SELECT pelf.element_link_id
860: FROM pay_element_links_f pelf
861: WHERE pelf.element_type_id=cp_element_type_id
862: AND cp_effective_date BETWEEN pelf.effective_start_date
863: AND pelf.effective_end_date
864: AND pelf.business_group_id=cp_business_group_id;

Line 881: l_element_link_id pay_element_links_f.element_link_id%TYPE;

877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;
878: l_get_ele_link c_get_ele_link%ROWTYPE;
879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;
882: l_rates_table_id VARCHAR2(80); --pay_user_tables.user_table_id%TYPE;
883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;
884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;
885: l_chk_eligibility VARCHAR2(1);

Line 2317: ,pay_element_links_f pel

2313: SELECT pet.element_type_id
2314: ,pel.element_link_id
2315: FROM pay_element_types_f pet
2316: ,pay_element_type_extra_info pete
2317: ,pay_element_links_f pel
2318: WHERE pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'
2319: AND pet.element_type_id=pete.element_type_id
2320: AND pete.element_type_id=pel.element_type_id
2321: AND pete.eei_information1=cp_vehicle_type