DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 2282: l_user_elm_name pay_element_types_f_tl.element_name%type;

2278: function get_user_elm_name(p_base_elm_name in varchar2)
2279: return varchar2
2280: is
2281: --
2282: l_user_elm_name pay_element_types_f_tl.element_name%type;
2283: --
2284: cursor csr_user_elm_name
2285: is
2286: select pett.element_name

Line 2288: pay_element_types_f_tl pett

2284: cursor csr_user_elm_name
2285: is
2286: select pett.element_name
2287: from pay_element_types_f pet,
2288: pay_element_types_f_tl pett
2289: where pet.element_name = p_base_elm_name
2290: and pett.element_type_id = pet.element_type_id
2291: and pett.language = userenv('LANG');
2292: --