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 1161: FROM pay_element_types_f pet

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

Line 1276: ,pay_element_types_f pet

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

Line 1294: ,pay_element_types_f pet

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