DBA Data[Home] [Help]

APPS.PQP_VAL_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 1277: ,pay_element_links_f pel

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
1281: and p_effective_date BETWEEN pee.effective_start_date

Line 1295: ,pay_element_links_f pel

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
1299: , pqp_vehicle_allocations_f pva