DBA Data[Home] [Help]

APPS.IGS_AD_SS_GEN_001 dependencies on FND_LOOKUP_VALUES

Line 5595: FROM FND_LOOKUP_VALUES lv

5591: sslkps.closed_flag <> 'Y');
5592:
5593: CURSOR c_phone_type IS
5594: SELECT lv.meaning lookup_desc
5595: FROM FND_LOOKUP_VALUES lv
5596: WHERE lv.LOOKUP_TYPE = 'PHONE_LINE_TYPE'
5597: AND lv.LANGUAGE(+) = USERENV('LANG')
5598: AND lv.VIEW_APPLICATION_ID = 222
5599: AND lv.SECURITY_GROUP_ID = 0

Line 5620: FROM FND_LOOKUP_VALUES lv,

5616: sslkps.closed_flag <> 'Y');
5617:
5618: CURSOR c_relation_type IS
5619: SELECT lv.meaning lookup_desc
5620: FROM FND_LOOKUP_VALUES lv,
5621: HZ_RELATIONSHIP_TYPES hz
5622: WHERE HZ.FORWARD_REL_CODE=lv.lookup_code
5623: AND hz.subject_type = 'PERSON'
5624: AND hz.object_type = 'PERSON'