DBA Data[Home] [Help]

APPS.PAY_ELEMENT_LINK_API dependencies on PAY_ELEMENT_LINKS_F

Line 132: l_standard_link_flag pay_element_links_f.standard_link_flag%type

128: --
129: l_proc varchar2(72) := g_package||'create_element_link';
130: l_effective_date date;
131:
132: l_standard_link_flag pay_element_links_f.standard_link_flag%type
133: := p_standard_link_flag;
134: l_cost_allocation_id number := p_cost_allocation_keyflex_id;
135: l_bal_allocation_id number := p_balancing_keyflex_id;
136:

Line 730: from pay_element_links_f

726: ,location_id
727: ,pay_basis_id
728: ,employment_category
729: ,people_group_id
730: from pay_element_links_f
731: where element_link_id = p_element_link_id
732: and l_effective_date between effective_start_date
733: and effective_end_date;
734:

Line 1296: from pay_element_links_f

1292:
1293: cursor csr_link_date_range is
1294: select min(effective_start_date) min_effective_start_date
1295: ,max(effective_end_date) max_effective_end_date
1296: from pay_element_links_f
1297: where element_link_id = p_element_link_id
1298: ;
1299: --
1300: begin