DBA Data[Home] [Help]

APPS.PQP_VAL_BUS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 968: ,pay_element_type_extra_info pete

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
972: WHERE pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'

Line 1164: ,pay_element_type_extra_info pete

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
1168: WHERE pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'