APPS.PAY_JP_CREATE_CMA_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;

15: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
16: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
17: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
18: c_elm pay_element_types_f.element_name%TYPE;
19: c_elm_tl pay_element_types_f_tl.element_name%TYPE;
20: c_elm_tl_max number := 30;
21: --
22: -- Global Variables
23: --

Line 59: o_elm_tl pay_element_types_f_tl.element_name%type;

55: p_elm_name in varchar2)
56: return varchar2
57: is
58: --
59: o_elm_tl pay_element_types_f_tl.element_name%type;
60: --
61: -- support only session lang based on case forms and srs session lang is same
62: cursor csr_elm_tl
63: is

Line 67: pay_element_types_f_tl pett

63: is
64: select /*+ ORDERD */
65: pett.element_name
66: from pay_element_types_f pet,
67: pay_element_types_f_tl pett
68: where pet.element_name = p_elm_name
69: and pet.legislation_code = 'JP'
70: and pett.element_type_id = pet.element_type_id
71: and pett.language = userenv('LANG');