DBA Data[Home] [Help]

APPS.PQP_VAL_BUS dependencies on PAY_INPUT_VALUES_F

Line 971: ,pay_input_values_f piv2

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
974: AND pete.element_type_id =pet.element_type_id
975: AND substr(pete.eei_information1,0,1) in ('C','P')

Line 1165: ,pay_input_values_f piv2

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
1168: AND pete.element_type_id =pet.element_type_id
1169: AND substr(pete.EEI_INFORMATION1,0,1) in ('C','P')

Line 1295: ,pay_input_values_f piv

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
1299: WHERE pee.ASSIGNMENT_ID=p_assignment_id