APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_LOOKUPS

Line 5170: FROM FND_LOOKUPS

5166:
5167: BEGIN
5168: SELECT 'Y'
5169: INTO l_temp
5170: FROM FND_LOOKUPS
5171: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
5172: AND LOOKUP_CODE = l_val1
5173: AND (ENABLED_FLAG = 'N' OR
5174: SYSDATE NOT BETWEEN

Line 5188: FROM FND_LOOKUPS

5184: -- Sued to populate section_name column.
5185:
5186: SELECT MEANING
5187: INTO l_val2
5188: FROM FND_LOOKUPS
5189: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
5190: AND LOOKUP_CODE = l_val1;
5191:
5192: -- Needed as we need to make sure that there is some default line group meaning

Line 5304: FROM FND_LOOKUPS

5300: P.KNOCKOUT_SCORE,
5301: P.SCORING_METHOD
5302: FROM PON_AUCTION_ATTRIBUTES P,
5303: (SELECT LOOKUP_CODE
5304: FROM FND_LOOKUPS
5305: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
5306: AND (ENABLED_FLAG = 'N'
5307: OR SYSDATE NOT BETWEEN NVL(START_DATE_ACTIVE,SYSDATE - 1 )
5308: AND NVL(END_DATE_ACTIVE,SYSDATE + 1 ))