DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_APPLICATION

Line 304: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL

300:
301: l_org_id := p_org_id;
302:
303: SELECT 'Y', RULE_OBJECT_ID INTO L_DUMMY, m_ruleObjectId FROM
304: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL
305: WHERE RULE_OBJECT_NAME = p_rule_object_name
306: AND FRO.APPLICATION_ID = APPL.APPLICATION_ID
307: AND APPL.APPLICATION_SHORT_NAME = p_application_short_name
308: AND

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

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;
1476: l_num_rows_processed INTEGER;
1477:

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

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);
1622:
1623: source_cursor INTEGER;