APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_ELEMENT_TYPES_F_TL

Line 70: ,pay_element_types_f_tl pettl

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

Line 659: l_element_name pay_element_types_f_tl.element_name%type;

655: ,p_owner_type in varchar2
656: )
657: is
658: l_proc varchar2(72) := g_package||'chk_ent_reprocess_date';
659: l_element_name pay_element_types_f_tl.element_name%type;
660: l_owner_type varchar2(10);
661: begin
662: hr_utility.set_location('Entering:'|| l_proc, 10);
663:

Line 750: l_element_name pay_element_types_f_tl.element_name%type;

746: )
747: is
748: l_proc varchar2(72) := g_package||'chk_retro_entry_deletable';
749: l_owner_type varchar2(10);
750: l_element_name pay_element_types_f_tl.element_name%type;
751: begin
752: hr_utility.set_location('Entering:'|| l_proc, 10);
753:
754: if p_owner_type = g_user then

Line 812: ,pay_element_types_f_tl pettl

808: pel.element_type_id
809: from
810: pay_element_entries_f pee
811: ,pay_element_links_f pel
812: ,pay_element_types_f_tl pettl
813: where
814: pee.element_entry_id = p_element_entry_id
815: and pee.assignment_id = nvl(p_assignment_id, pee.assignment_id)
816: and pee.creator_type in ('A', 'F', 'H', 'Q', 'SP', 'UT', 'M', 'S')

Line 891: l_element_name pay_element_types_f_tl.element_name%type;

887: --
888: l_proc varchar2(72) := g_package||'get_default_retro_component_id';
889:
890: l_retro_component_id number;
891: l_element_name pay_element_types_f_tl.element_name%type;
892: --
893: begin
894: hr_utility.set_location('Entering:'|| l_proc, 10);
895: --

Line 1041: l_element_name pay_element_types_f_tl.element_name%type;

1037: ,p_retro_component_id in number
1038: )
1039: is
1040: l_dummy number;
1041: l_element_name pay_element_types_f_tl.element_name%type;
1042: l_component_name pay_retro_components.component_name%type;
1043: --
1044: cursor csr_rcu
1045: is

Line 1060: pay_element_types_f_tl pettl

1056: is
1057: select
1058: pettl.element_name
1059: from
1060: pay_element_types_f_tl pettl
1061: where
1062: pettl.element_type_id = p_element_type_id
1063: and pettl.language = userenv('lang')
1064: ;

Line 1952: l_element_name pay_element_types_f_tl.element_name%type;

1948: l_new_rec t_retro_ent_rec;
1949: l_assignment_id number;
1950: l_asg_owner_type varchar2(10);
1951: l_element_type_id number;
1952: l_element_name pay_element_types_f_tl.element_name%type;
1953: l_business_group_id number;
1954: l_legislation_code per_business_groups.legislation_code%type;
1955: l_component_name pay_retro_components.component_name%type;
1956: l_payroll_id number;