APPS.PAY_ADHOC_UTILS_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 27: pay_element_types_f_tl pettl,

23: pettl.element_name element_name,
24: pectl.classification_name classification
25: FROM pay_element_entries_f pee,
26: pay_element_types_f pet,
27: pay_element_types_f_tl pettl,
28: pay_element_entry_values_f peev,
29: pay_input_values_f piv,
30: pay_input_values_f_tl pivtl ,
31: pay_element_classifications pec,

Line 286: pay_element_types_f_tl pettl

282:
283: cursor csr_element is
284: select pettl.element_name
285: from pay_element_types_f pet,
286: pay_element_types_f_tl pettl
287: where pet.element_type_id = pettl.element_type_id
288: and pettl.language = userenv('LANG')
289: and pet.element_type_id = p_element_type_id
290: and p_effective_date between pet.effective_start_date and pet.effective_end_date;

Line 960: pay_element_types_f_tl pettl,

956: --
957: cursor csr_element is
958: select pettl.element_name
959: from pay_element_types_f pet,
960: pay_element_types_f_tl pettl,
961: pay_element_entries_f pee
962: where pet.element_type_id = pettl.element_type_id
963: and pettl.language = userenv('LANG')
964: and pet.element_type_id = pee.element_type_id