DBA Data[Home] [Help]

APPS.IGI_IGIRRTRH_XMLP_PKG dependencies on AR_LOOKUPS

Line 100: AR_LOOKUPS LOOK1,

96: INITCAP(LOOK1.MEANING) C_YES,
97: INITCAP(LOOK2.MEANING) C_NO
98: INTO L_YES,L_NO
99: FROM
100: AR_LOOKUPS LOOK1,
101: AR_LOOKUPS LOOK2
102: WHERE LOOK1.LOOKUP_TYPE = 'YES/NO'
103: AND LOOK1.LOOKUP_CODE = 'Y'
104: AND LOOK2.LOOKUP_TYPE = 'YES/NO'

Line 101: AR_LOOKUPS LOOK2

97: INITCAP(LOOK2.MEANING) C_NO
98: INTO L_YES,L_NO
99: FROM
100: AR_LOOKUPS LOOK1,
101: AR_LOOKUPS LOOK2
102: WHERE LOOK1.LOOKUP_TYPE = 'YES/NO'
103: AND LOOK1.LOOKUP_CODE = 'Y'
104: AND LOOK2.LOOKUP_TYPE = 'YES/NO'
105: AND LOOK2.LOOKUP_CODE = 'N';

Line 256: AR_LOOKUPS

252: RTRIM(RPAD(MEANING
253: ,11))
254: INTO L_MEANING
255: FROM
256: AR_LOOKUPS
257: WHERE LOOKUP_TYPE = L_TYPE
258: AND LOOKUP_CODE = L_CODE;
259: RETURN (L_MEANING);
260: END AR_LOOKUP;