DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PAY_ELEMENT_LINKS_F

Line 223: pay_element_links_f pel,

219: ,p_plan_category VARCHAR2) IS
220: SELECT pap.accrual_plan_id
221: FROM pay_accrual_plans pap,
222: pay_element_entries_f pee,
223: pay_element_links_f pel,
224: pay_element_types_f pet
225: WHERE pee.assignment_id = p_assignment_id
226: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
227: AND pel.element_link_id = pee.element_link_id

Line 1884: pay_element_links_f pel,

1880: --
1881: CURSOR c_iv IS
1882: SELECT piv.input_value_id
1883: FROM pay_element_entries_f pee,
1884: pay_element_links_f pel,
1885: pay_input_values_f piv
1886: WHERE pee.element_entry_id = p_element_entry_id
1887: AND pee.element_link_id = pel.element_link_id
1888: AND pel.element_type_id = piv.element_type_id