APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 363: FROM fnd_id_flex_structures_vl ctx,

359: ) AS
360:
361: CURSOR csr_get_tag_name (p_id_flex_structure_code varchar2) IS
362: SELECT TRANSLATE (UPPER(seg.segment_name), ' /','__')
363: FROM fnd_id_flex_structures_vl ctx,
364: fnd_id_flex_segments_vl seg
365: WHERE ctx.id_flex_num = seg.id_flex_num
366: AND ctx.id_flex_code = seg.id_flex_code
367: AND seg.id_flex_code = 'BANK'

Line 373: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;

369: AND seg.application_column_name = UPPER(p_node);
370:
371: l_proc_name varchar2(100);
372: l_tag_name varchar2(500);
373: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;
374:
375: BEGIN
376: l_proc_name := g_proc_name || 'LOAD_XML-2';
377: hr_utility_trace ('Entering '||l_proc_name);