APPS.IGC_CC_PO_INTERFACE_PKG dependencies on PO_LINE_TYPES_TL

Line 220: l_line_type_id po_line_types_tl.line_type_id%TYPE;

216: p_yr_start_date IN DATE,
217: p_yr_end_date IN DATE)
218: IS
219: l_po_lines_rec po_lines_all%ROWTYPE;
220: l_line_type_id po_line_types_tl.line_type_id%TYPE;
221: E_CC_PO_LINE_TYPE EXCEPTION;
222:
223: -- M van der geest, added 18-OKT-2001
224: l_icx_lang VARCHAR2(30);

Line 253: FROM po_line_types_tl

249: fnd_profile.get('ICX_LANGUAGE',l_icx_lang);
250:
251: SELECT line_type_id
252: INTO l_line_type_id
253: FROM po_line_types_tl
254: WHERE line_type = 'IGC CONTRACT COMMITMENT'
255: AND LANGUAGE = DECODE(l_icx_lang,'AMERICAN','US',
256: 'DUTCH','NL','US');
257: