APPS.PY_DK_TAX_CARD dependencies on PAY_ELEMENT_TYPES_F_TL

Line 95: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;

91: l_input_value_id9 pay_input_values_f.input_value_id%TYPE;
92: l_input_value_id10 pay_input_values_f.input_value_id%TYPE;
93: l_input_value_id11 pay_input_values_f.input_value_id%TYPE;
94: -- Added for Flugger fix
95: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
96:
97:
98: CURSOR input_values_csr IS
99: SELECT

Line 161: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT

157:
158: --Added for Flugger fix
159: select ELEMENTTL.element_name
160: into l_element_name_tl
161: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
162: where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
163: and ELEMENT.LEGISLATION_CODE ='DK'
164: and ELEMENT.ELEMENT_NAME = 'Tax Card'
165: AND ELEMENTTL.LANGUAGE = USERENV('LANG');