DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_LINKS_F

Line 1847: pay_element_links_f pel

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

Line 4573: from pay_element_links_f EL

4569: p_business_group_id number
4570: ,p_element_type_id number
4571: ) is
4572: select EL.element_link_id
4573: from pay_element_links_f EL
4574: where EL.business_group_id = p_business_group_id
4575: and EL.element_type_id = p_element_type_id
4576: and EL.link_to_all_payrolls_flag = 'Y'
4577: and EL.payroll_id is null