APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_LOOKUPS

Line 4123: FROM FND_LOOKUPS

4119:
4120: BEGIN
4121: SELECT 'Y'
4122: INTO l_temp
4123: FROM FND_LOOKUPS
4124: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
4125: AND LOOKUP_CODE = l_val1
4126: AND (ENABLED_FLAG = 'N' OR
4127: SYSDATE NOT BETWEEN

Line 4141: FROM FND_LOOKUPS

4137: -- Sued to populate section_name column.
4138:
4139: SELECT MEANING
4140: INTO l_val2
4141: FROM FND_LOOKUPS
4142: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
4143: AND LOOKUP_CODE = l_val1;
4144:
4145: -- Needed as we need to make sure that there is some default line group meaning

Line 4257: FROM FND_LOOKUPS

4253: P.KNOCKOUT_SCORE,
4254: P.SCORING_METHOD
4255: FROM PON_AUCTION_ATTRIBUTES P,
4256: (SELECT LOOKUP_CODE
4257: FROM FND_LOOKUPS
4258: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
4259: AND (ENABLED_FLAG = 'N'
4260: OR SYSDATE NOT BETWEEN NVL(START_DATE_ACTIVE,SYSDATE - 1 )
4261: AND NVL(END_DATE_ACTIVE,SYSDATE + 1 ))