APPS.PAY_ETU_BUS dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 29: , pay_element_type_usages_f etu

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_element_type_usages_f etu
30: where etu.element_type_usage_id = p_element_type_usage_id
31: and pbg.business_group_id = etu.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_element_type_usages_f etu

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_element_type_usages_f etu
90: where etu.element_type_usage_id = p_element_type_usage_id
91: and pbg.business_group_id (+) = etu.business_group_id;
92: --
93: -- Declare local variables

Line 317: l_legislation_code pay_element_type_usages_f.legislation_code%TYPE := Null;

313: ,p_business_group_id in number
314: ,p_legislation_code in varchar2) is
315: --
316: l_proc varchar2(72) := g_package||'chk_run_type_id';
317: l_legislation_code pay_element_type_usages_f.legislation_code%TYPE := Null;
318: l_exists varchar2(1);
319: --
320: CURSOR csr_chk_user_run_type(p_leg_code varchar2) is
321: select 'Y'

Line 489: l_legislation_code pay_element_type_usages_f.legislation_code%TYPE := Null;

485: ,p_business_group_id in number
486: ,p_legislation_code in varchar2) is
487: --
488: l_proc varchar2(72) := g_package||'chk_element_type_id';
489: l_legislation_code pay_element_type_usages_f.legislation_code%TYPE := Null;
490: l_exists varchar2(1);
491: --
492: CURSOR csr_chk_user_element_type(p_leg_code varchar2) is
493: select 'Y'