APPS.PAY_DK_TC_DP_UPLOAD dependencies on PAY_ELEMENT_TYPES_F_TL

Line 67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;

63: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
64: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
70: l_input_value_name1 VARCHAR2(80);
71: l_input_value_name2 VARCHAR2(80);

Line 531: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT

527:
528: --Added for Flugger fix
529: select ELEMENTTL.element_name
530: into l_element_name_tl
531: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
532: where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
533: and ELEMENT.LEGISLATION_CODE ='DK'
534: and ELEMENT.ELEMENT_NAME = 'Tax Card'
535: AND ELEMENTTL.LANGUAGE = USERENV('LANG');

Line 539: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT

535: AND ELEMENTTL.LANGUAGE = USERENV('LANG');
536:
537: select ELEMENTTL.element_name
538: into l_element_name
539: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
540: where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
541: and ELEMENT.LEGISLATION_CODE ='DK'
542: and ELEMENT.ELEMENT_NAME = 'Tax Card'
543: AND ELEMENTTL.LANGUAGE = 'US';