APPS.PAY_RETRO_COMP_USAGE_INTERNAL dependencies on PAY_ELEMENT_TYPES_F

Line 54: pay_element_types_f etp

50: ,rcu1.reprocess_type
51: ,etp.business_group_id
52: ,etp.legislation_code
53: from
54: pay_element_types_f etp
55: ,pay_retro_component_usages rcu1
56: where
57: etp.element_type_id = p_element_type_id
58: and p_effective_date between etp.effective_start_date

Line 209: l_classification_id pay_element_types_f.classification_id%type;

205: l_proc varchar2(72) := g_package||'delete_child_retro_comp_usages';
206:
207: --Bug#4075607
208: --local variables to hold element type details..
209: l_classification_id pay_element_types_f.classification_id%type;
210: l_business_group_id pay_element_types_f.business_group_id%type;
211: l_legislation_code pay_element_types_f.legislation_code%type;
212: --
213: begin

Line 210: l_business_group_id pay_element_types_f.business_group_id%type;

206:
207: --Bug#4075607
208: --local variables to hold element type details..
209: l_classification_id pay_element_types_f.classification_id%type;
210: l_business_group_id pay_element_types_f.business_group_id%type;
211: l_legislation_code pay_element_types_f.legislation_code%type;
212: --
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 211: l_legislation_code pay_element_types_f.legislation_code%type;

207: --Bug#4075607
208: --local variables to hold element type details..
209: l_classification_id pay_element_types_f.classification_id%type;
210: l_business_group_id pay_element_types_f.business_group_id%type;
211: l_legislation_code pay_element_types_f.legislation_code%type;
212: --
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: --

Line 291: From pay_element_types_f etp

287: Into
288: x_business_group_id
289: ,x_legislation_code
290: ,x_classification_id
291: From pay_element_types_f etp
292: Where etp.element_type_id = p_element_type_id
293: And p_effective_date between etp.effective_start_date and etp.effective_end_date ;
294:
295: End get_ele_typ_det;