DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_ELEMENT_TYPES_F

Line 275: pay_element_types_f pet,

271: select piv.input_value_id
272: into l_input_value_id
273: from pay_input_values_f_tl pivtl,
274: pay_input_values_f piv,
275: pay_element_types_f pet,
276: pay_element_types_f_tl pettl,
277: per_business_groups pbg
278: where pbg.business_group_id = p_business_group_id
279: and pettl.element_name = p_element_name

Line 276: pay_element_types_f_tl pettl,

272: into l_input_value_id
273: from pay_input_values_f_tl pivtl,
274: pay_input_values_f piv,
275: pay_element_types_f pet,
276: pay_element_types_f_tl pettl,
277: per_business_groups pbg
278: where pbg.business_group_id = p_business_group_id
279: and pettl.element_name = p_element_name
280: and pettl.language = p_language_code

Line 2115: from pay_element_types_f pet

2111: l_element_type_id number;
2112: begin
2113: select pet.element_type_id
2114: into l_element_type_id
2115: from pay_element_types_f pet
2116: where pet.element_name = p_element_name
2117: and business_group_id + 0 = p_business_group_id
2118: and p_effective_date between
2119: pet.effective_start_date and pet.effective_end_date;