DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_APPLICATION

Line 313: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL

309: END IF;
310: -- Added for Bug 9025784 - End
311:
312: SELECT 'Y', RULE_OBJECT_ID INTO L_DUMMY, m_ruleObjectId FROM
313: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL
314: WHERE RULE_OBJECT_NAME = p_rule_object_name
315: AND FRO.APPLICATION_ID = APPL.APPLICATION_ID
316: AND APPL.APPLICATION_SHORT_NAME = p_application_short_name
317: AND

Line 1481: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);

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;
1484: l_num_rows_processed INTEGER;
1485:

Line 1627: AND APPLICATION_ID IN (SELECT APPLICATION_ID FROM FND_APPLICATION_VL WHERE APPLICATION_SHORT_NAME = p_FlexFieldAppShortName);

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);
1630:
1631: source_cursor INTEGER;