eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 404: FROM pay_element_type_extra_info pete

400:
401: CURSOR c_ele_type (cp_element_type_id NUMBER)
402: IS
403: SELECT NVL(pete.eei_information2 ,'N') ele_type
404: FROM pay_element_type_extra_info pete
405: WHERE pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
406: AND pete.element_type_id= cp_element_type_id;
407:
408: l_proc varchar2(72) := g_package ||'get_asg_element';

Line 520: pay_element_type_extra_info pete,

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')
524: AND asgt.business_group_id = link.business_group_id

Line 642: pay_element_type_extra_info pete,

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')
646: AND asgt.business_group_id = link.business_group_id

Line 1757: FROM pay_element_type_extra_info pete

1753:
1754: CURSOR c_ele_type (cp_element_type_id NUMBER)
1755: IS
1756: SELECT NVL(pete.eei_information2 ,'N') ele_type
1757: FROM pay_element_type_extra_info pete
1758: WHERE pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
1759: AND pete.element_type_id= cp_element_type_id;
1760:
1761: l_ele_type c_ele_type%ROWTYPE;

Line 2302: ,pay_element_type_extra_info pete

2298: IS
2299: SELECT pet.element_type_id
2300: ,pel.element_link_id
2301: FROM pay_element_types_f pet
2302: ,pay_element_type_extra_info pete
2303: ,pay_element_links_f pel
2304: WHERE pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'
2305: AND pet.element_type_id=pete.element_type_id
2306: AND pete.element_type_id=pel.element_type_id