APPS.PAY_IP_STARTUP_UTIL dependencies on FND_ID_FLEX_STRUCTURES

Line 1579: FROM fnd_id_flex_structures_vl

1575: CURSOR duplicate_structure_check (p_application_id NUMBER,
1576: p_flexfield_code VARCHAR2,
1577: p_structure_title VARCHAR2) IS
1578: SELECT null
1579: FROM fnd_id_flex_structures_vl
1580: WHERE application_id = p_application_id
1581: AND id_flex_code = p_flexfield_code
1582: AND id_flex_structure_name = p_structure_title;
1583:

Line 1647: FROM fnd_id_flex_structures ifs

1643: WHERE application_short_name = p_appl_short_name;
1644:
1645: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
1646: INTO l_structure.structure_number
1647: FROM fnd_id_flex_structures ifs
1648: WHERE ifs.application_id = l_application_id
1649: AND ifs.id_flex_code = p_flex_code
1650: AND ifs.id_flex_num < 101;
1651:

Line 3128: l_structure_code fnd_id_flex_structures.id_flex_structure_code%type;

3124: l_territory FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
3125: l_territory_with_code VARCHAR2(100);
3126: l_payroll_installed VARCHAR2(1);
3127: l_segment_used NUMBER;--Bug#4938455. Changed varchar2 to number.
3128: l_structure_code fnd_id_flex_structures.id_flex_structure_code%type;
3129:
3130: l_list_of_ctxt_string VARCHAR2(2000);
3131: lv_request_status VARCHAR2(30);
3132:

Line 3149: from fnd_id_flex_structures

3145: and status = 'I';
3146:
3147: cursor csr_flex_struct (p_id_flex_num number) is
3148: select id_flex_structure_code
3149: from fnd_id_flex_structures
3150: where id_flex_code = 'SCL'
3151: and id_flex_num = p_id_flex_num;
3152:
3153: BEGIN

Line 3317: FROM fnd_id_flex_structures

3313: segment creation is also skipped */
3314:
3315: SELECT MIN(id_flex_num)
3316: INTO l_id_flex_num
3317: FROM fnd_id_flex_structures
3318: WHERE id_flex_code = 'SCL'
3319: AND id_flex_structure_code like
3320: p_legislation_code||'_STATUTORY_INFO'||'%';
3321: