APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_ELEMENT_TYPES_F_TL

Line 69: ,pay_element_types_f_tl pettl

65: pettl.element_name
66: from
67: pay_element_entries_f pee
68: ,pay_element_links_f pel
69: ,pay_element_types_f_tl pettl
70: where
71: pee.element_entry_id = p_element_entry_id
72: and pel.element_link_id = pee.element_link_id
73: and pee.effective_start_date between pel.effective_start_date

Line 691: l_element_name pay_element_types_f_tl.element_name%type;

687: ,p_owner_type in varchar2
688: )
689: is
690: l_proc varchar2(72) := g_package||'chk_ent_reprocess_date';
691: l_element_name pay_element_types_f_tl.element_name%type;
692: l_owner_type varchar2(10);
693: begin
694: hr_utility.set_location('Entering:'|| l_proc, 10);
695:

Line 782: l_element_name pay_element_types_f_tl.element_name%type;

778: )
779: is
780: l_proc varchar2(72) := g_package||'chk_retro_entry_deletable';
781: l_owner_type varchar2(10);
782: l_element_name pay_element_types_f_tl.element_name%type;
783: begin
784: hr_utility.set_location('Entering:'|| l_proc, 10);
785:
786: if p_owner_type = g_user then

Line 844: ,pay_element_types_f_tl pettl

840: pel.element_type_id
841: from
842: pay_element_entries_f pee
843: ,pay_element_links_f pel
844: ,pay_element_types_f_tl pettl
845: where
846: pee.element_entry_id = p_element_entry_id
847: and pee.assignment_id = nvl(p_assignment_id, pee.assignment_id)
848: and pee.creator_type in ('A', 'F', 'H', 'Q', 'SP', 'UT', 'M', 'S')

Line 923: l_element_name pay_element_types_f_tl.element_name%type;

919: --
920: l_proc varchar2(72) := g_package||'get_default_retro_component_id';
921:
922: l_retro_component_id number;
923: l_element_name pay_element_types_f_tl.element_name%type;
924: --
925: begin
926: hr_utility.set_location('Entering:'|| l_proc, 10);
927: --

Line 1073: l_element_name pay_element_types_f_tl.element_name%type;

1069: ,p_retro_component_id in number
1070: )
1071: is
1072: l_dummy number;
1073: l_element_name pay_element_types_f_tl.element_name%type;
1074: l_component_name pay_retro_components.component_name%type;
1075: --
1076: cursor csr_rcu
1077: is

Line 1092: pay_element_types_f_tl pettl

1088: is
1089: select
1090: pettl.element_name
1091: from
1092: pay_element_types_f_tl pettl
1093: where
1094: pettl.element_type_id = p_element_type_id
1095: and pettl.language = userenv('lang')
1096: ;

Line 1907: l_element_name pay_element_types_f_tl.element_name%type;

1903: l_new_rec t_retro_ent_rec;
1904: l_assignment_id number;
1905: l_asg_owner_type varchar2(10);
1906: l_element_type_id number;
1907: l_element_name pay_element_types_f_tl.element_name%type;
1908: l_business_group_id number;
1909: l_legislation_code per_business_groups.legislation_code%type;
1910: l_component_name pay_retro_components.component_name%type;
1911: l_payroll_id number;