APPS.PAY_IP_STARTUP_UTIL dependencies on FND_ID_FLEX_STRUCTURES

Line 1210: FROM fnd_id_flex_structures_vl

1206: CURSOR duplicate_structure_check (p_application_id NUMBER,
1207: p_flexfield_code VARCHAR2,
1208: p_structure_title VARCHAR2) IS
1209: SELECT null
1210: FROM fnd_id_flex_structures_vl
1211: WHERE application_id = p_application_id
1212: AND id_flex_code = p_flexfield_code
1213: AND id_flex_structure_name = p_structure_title;
1214:

Line 1278: FROM fnd_id_flex_structures ifs

1274: WHERE application_short_name = p_appl_short_name;
1275:
1276: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
1277: INTO l_structure.structure_number
1278: FROM fnd_id_flex_structures ifs
1279: WHERE ifs.application_id = l_application_id
1280: AND ifs.id_flex_code = p_flex_code
1281: AND ifs.id_flex_num < 101;
1282:

Line 1994: l_structure_code fnd_id_flex_structures.id_flex_structure_code%type;

1990: l_territory FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
1991: l_territory_with_code VARCHAR2(100);
1992: l_payroll_installed VARCHAR2(1);
1993: l_segment_used NUMBER;--Bug#4938455. Changed varchar2 to number.
1994: l_structure_code fnd_id_flex_structures.id_flex_structure_code%type;
1995:
1996: CURSOR csr_payroll_installed is
1997: select 1 from fnd_product_installations
1998: where application_id = 801

Line 2003: from fnd_id_flex_structures

1999: and status = 'I';
2000:
2001: cursor csr_flex_struct (p_id_flex_num number) is
2002: select id_flex_structure_code
2003: from fnd_id_flex_structures
2004: where id_flex_code = 'SCL'
2005: and id_flex_num = p_id_flex_num;
2006:
2007: BEGIN

Line 2124: FROM fnd_id_flex_structures

2120: segment creation is also skipped */
2121:
2122: SELECT MIN(id_flex_num)
2123: INTO l_id_flex_num
2124: FROM fnd_id_flex_structures
2125: WHERE id_flex_code = 'SCL'
2126: AND id_flex_structure_code like
2127: p_legislation_code||'_STATUTORY_INFO'||'%';
2128: