APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 302: FROM fnd_id_flex_structures_vl ctx,

298: ) AS
299:
300: CURSOR csr_get_tag_name (p_id_flex_structure_code varchar2) IS
301: SELECT TRANSLATE (UPPER(seg.segment_name), ' /','__')
302: FROM fnd_id_flex_structures_vl ctx,
303: fnd_id_flex_segments_vl seg
304: WHERE ctx.id_flex_num = seg.id_flex_num
305: AND ctx.id_flex_code = seg.id_flex_code
306: AND seg.id_flex_code = 'BANK'

Line 312: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;

308: AND seg.application_column_name = UPPER(p_node);
309:
310: l_proc_name varchar2(100);
311: l_tag_name varchar2(500);
312: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;
313:
314: BEGIN
315: l_proc_name := g_proc_name || 'LOAD_XML-2';
316: hr_utility_trace ('Entering '||l_proc_name);