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 1163: ,pay_element_entries_f pee

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

Line 1274: FROM pay_element_entries_f PEE

1270: is
1271: CURSOR c_chk_ni_car_pri
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

Line 1292: FROM pay_element_entries_f PEE

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