APPS.FUN_RULE_PUB dependencies on FND_DESCRIPTIVE_FLEXS

Line 1471: FROM FND_DESCRIPTIVE_FLEXS FDF

1467: p_FlexFieldAppShortName IN VARCHAR2) RETURN VARCHAR2 IS
1468:
1469: CURSOR DFF_CUR(p_FlexFieldName IN VARCHAR2, p_FlexFieldAppShortName IN VARCHAR2) IS
1470: SELECT DISTINCT FDF.APPLICATION_TABLE_NAME
1471: FROM FND_DESCRIPTIVE_FLEXS FDF
1472: WHERE FDF.DESCRIPTIVE_FLEXFIELD_NAME = p_FlexFieldName
1473: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);
1474:
1475: source_cursor INTEGER;

Line 1617: FROM FND_DESCRIPTIVE_FLEXS FDF

1613: p_FlexFieldAppShortName IN VARCHAR2) RETURN VARCHAR2 IS
1614:
1615: CURSOR DFF_CUR(p_FlexFieldName IN VARCHAR2, p_FlexFieldAppShortName IN VARCHAR2) IS
1616: SELECT DISTINCT FDF.APPLICATION_TABLE_NAME
1617: FROM FND_DESCRIPTIVE_FLEXS FDF
1618: WHERE FDF.DESCRIPTIVE_FLEXFIELD_NAME = p_FlexFieldName
1619: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);
1620:
1621: l_DFFTableName VARCHAR2(30);