APPS.PAY_ADHOC_UTILS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 26: pay_element_types_f pet,

22: hr_bis.bis_decode_lookup('PROCESSING_TYPE',pet.PROCESSING_TYPE) Recurring,
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 ,

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 281: l_element_name pay_element_types_f.element_name%type;

277: RETURN VARCHAR2
278: IS
279: --
280: l_proc constant varchar2(72) := g_package||'decode_element_type';
281: l_element_name pay_element_types_f.element_name%type;
282:
283: cursor csr_element is
284: select pettl.element_name
285: from pay_element_types_f pet,

Line 285: from pay_element_types_f pet,

281: l_element_name pay_element_types_f.element_name%type;
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

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 955: l_element_name pay_element_types_f.element_name%type;

951: p_payroll_run_date date)
952: RETURN VARCHAR2 IS
953: --
954: l_proc constant varchar2(72) := g_package||'get_element_name';
955: l_element_name pay_element_types_f.element_name%type;
956: --
957: cursor csr_element is
958: select pettl.element_name
959: from pay_element_types_f pet,

Line 959: from pay_element_types_f pet,

955: l_element_name pay_element_types_f.element_name%type;
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')

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