APPS.PAY_LIV_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 31: , pay_element_links_f pel

27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups_perf pbg
30: , pay_link_input_values_f liv
31: , pay_element_links_f pel
32: where liv.link_input_value_id = p_link_input_value_id
33: and liv.element_link_id = pel.element_link_id
34: and pbg.business_group_id = pel.business_group_id;
35: --

Line 97: , pay_element_links_f pel

93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups_perf pbg
96: , pay_link_input_values_f liv
97: , pay_element_links_f pel
98: where liv.link_input_value_id = p_link_input_value_id
99: and liv.element_link_id = pel.element_link_id
100: and pbg.business_group_id = pel.business_group_id;
101: --

Line 316: (p_base_table_name => 'pay_element_links_f'

312: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.INPUT_VALUE_ID');
313: End If;
314: If ((nvl(p_element_link_id, hr_api.g_number) <> hr_api.g_number) and
315: NOT (dt_api.check_min_max_dates
316: (p_base_table_name => 'pay_element_links_f'
317: ,p_base_key_column => 'ELEMENT_LINK_ID'
318: ,p_base_key_value => p_element_link_id
319: ,p_from_date => p_validation_start_date
320: ,p_to_date => p_validation_end_date))) Then

Line 696: l_costable_type pay_element_links_f.costable_type%type;

692: ,p_costed_flag in varchar2
693: ) is
694: --
695: l_proc varchar2(72) := g_package||'chk_costed_flag';
696: l_costable_type pay_element_links_f.costable_type%type;
697: l_uom pay_input_values_f.uom%type;
698: l_name pay_input_values_f.name%type;
699:
700: Cursor C_element_link

Line 703: from pay_element_links_f

699:
700: Cursor C_element_link
701: is
702: select costable_type
703: from pay_element_links_f
704: where element_link_id = p_element_link_id
705: and p_effective_date between effective_start_date
706: and effective_end_date;
707:

Line 936: l_business_group_id pay_element_links_f.business_group_id%type;

932:
933: ) is
934: --
935: l_proc varchar2(72) := g_package||'update_validate';
936: l_business_group_id pay_element_links_f.business_group_id%type;
937: l_formula_id number;
938: --
939: Cursor c_business_group_id
940: is

Line 942: from pay_element_links_f

938: --
939: Cursor c_business_group_id
940: is
941: select business_group_id
942: from pay_element_links_f
943: where element_link_id = p_rec.element_link_id;
944: --
945: Cursor c_formula
946: is