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 1167: ,pay_input_values_f piv2

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

Line 1297: ,pay_input_values_f piv

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
1299: , pqp_vehicle_allocations_f pva
1300: ,pqp_vehicle_repository_f pvr
1301: WHERE pee.ASSIGNMENT_ID=p_assignment_id