DBA Data[Home] [Help]

APPS.PQP_VAL_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 1275: ,pay_element_links_f pel

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

Line 1293: ,pay_element_links_f pel

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