DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 2273: l_user_elm_name pay_element_types_f_tl.element_name%type;

2269: function get_user_elm_name(p_base_elm_name in varchar2)
2270: return varchar2
2271: is
2272: --
2273: l_user_elm_name pay_element_types_f_tl.element_name%type;
2274: --
2275: cursor csr_user_elm_name
2276: is
2277: select pett.element_name

Line 2279: pay_element_types_f_tl pett

2275: cursor csr_user_elm_name
2276: is
2277: select pett.element_name
2278: from pay_element_types_f pet,
2279: pay_element_types_f_tl pett
2280: where pet.element_name = p_base_elm_name
2281: and pett.element_type_id = pet.element_type_id
2282: and pett.language = userenv('LANG');
2283: --