APPS.FUN_RULE_PUB dependencies on FND_DESCRIPTIVE_FLEXS

Line 1479: FROM FND_DESCRIPTIVE_FLEXS FDF

1475: p_FlexFieldAppShortName IN VARCHAR2) RETURN VARCHAR2 IS
1476:
1477: CURSOR DFF_CUR(p_FlexFieldName IN VARCHAR2, p_FlexFieldAppShortName IN VARCHAR2) IS
1478: SELECT DISTINCT FDF.APPLICATION_TABLE_NAME
1479: FROM FND_DESCRIPTIVE_FLEXS FDF
1480: WHERE FDF.DESCRIPTIVE_FLEXFIELD_NAME = p_FlexFieldName
1481: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);
1482:
1483: source_cursor INTEGER;

Line 1625: FROM FND_DESCRIPTIVE_FLEXS FDF

1621: p_FlexFieldAppShortName IN VARCHAR2) RETURN VARCHAR2 IS
1622:
1623: CURSOR DFF_CUR(p_FlexFieldName IN VARCHAR2, p_FlexFieldAppShortName IN VARCHAR2) IS
1624: SELECT DISTINCT FDF.APPLICATION_TABLE_NAME
1625: FROM FND_DESCRIPTIVE_FLEXS FDF
1626: WHERE FDF.DESCRIPTIVE_FLEXFIELD_NAME = p_FlexFieldName
1627: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);
1628:
1629: l_DFFTableName VARCHAR2(30);