DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_LINKS_F

Line 1845: pay_element_links_f pel

1841: begin
1842: select piv.input_value_id
1843: into l_iv_id
1844: from pay_input_values_f piv,
1845: pay_element_links_f pel
1846: where pel.element_link_id= p_element_link_id
1847: and pel.element_type_id = piv.element_type_id
1848: and piv.name = g_legislation_contexts(i).input_value_name
1849: and piv.effective_start_date = START_OF_TIME

Line 4280: from pay_element_links_f EL

4276: p_business_group_id number
4277: ,p_element_type_id number
4278: ) is
4279: select EL.element_link_id
4280: from pay_element_links_f EL
4281: where EL.business_group_id = p_business_group_id
4282: and EL.element_type_id = p_element_type_id
4283: and EL.link_to_all_payrolls_flag = 'Y'
4284: and EL.payroll_id is null