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_VAL_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 967: FROM pay_element_types_f pet

963: CURSOR c_claim_count_cursor
964: (cp_registration_number VARCHAR2,
965: cp_assignment_id NUMBER ) IS
966: SELECT count(*)
967: FROM pay_element_types_f pet
968: ,pay_element_type_extra_info pete
969: ,pay_element_entries_f pee
970: ,pay_element_entry_values_f peev2
971: ,pay_input_values_f piv2

Line 1163: FROM pay_element_types_f pet

1159: --Get the claim count for future and current date tracks
1160: CURSOR c_claim_count_cursor(cp_registration_number VARCHAR2,
1161: cp_assignment_id NUMBER ) IS
1162: SELECT count(*)
1163: FROM pay_element_types_f pet
1164: ,pay_element_type_extra_info pete
1165: ,pay_element_entries_f pee
1166: ,pay_element_entry_values_f peev2
1167: ,pay_input_values_f piv2

Line 1278: ,pay_element_types_f pet

1274: IS
1275: SELECT pee.element_entry_id element_entry_id
1276: FROM pay_element_entries_f PEE
1277: ,pay_element_links_f pel
1278: ,pay_element_types_f pet
1279: WHERE pee.assignment_id=p_assignment_id
1280: AND pel.business_group_id=p_business_group_id
1281: and p_effective_date BETWEEN pee.effective_start_date
1282: AND pee.effective_end_date

Line 1296: ,pay_element_types_f pet

1292: is
1293: SELECT pee.element_entry_id element_entry_id
1294: FROM pay_element_entries_f PEE
1295: ,pay_element_links_f pel
1296: ,pay_element_types_f pet
1297: ,pay_input_values_f piv
1298: , pay_element_entry_values_f peev
1299: , pqp_vehicle_allocations_f pva
1300: ,pqp_vehicle_repository_f pvr