APPS.PQP_VAL_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 969: ,pay_element_entries_f pee

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
972: WHERE pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'
973: AND pet.business_group_id=p_rec.business_group_id

Line 1165: ,pay_element_entries_f pee

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
1168: WHERE pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
1169: AND pet.business_group_id=p_rec.business_group_id

Line 1276: FROM pay_element_entries_f PEE

1272: is
1273: CURSOR c_chk_ni_car_pri
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

Line 1294: FROM pay_element_entries_f PEE

1290:
1291: CURSOR c_chk_sec_car (cp_allocation_id IN NUMBER)
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