APPS.JA_CN_APAR_COMMON_PKG dependencies on FND_LOOKUP_VALUES

Line 57: FROM fnd_lookup_values flv

53: CURSOR doc_type_cur
54: IS
55: SELECT flv.lookup_code Doc_Type_Num
56: , flv.meaning Doc_Num
57: FROM fnd_lookup_values flv
58: WHERE flv.lookup_type = 'JA_CN_DOCUMENT_TYPE'
59: AND flv.language = USERENV('LANG');
60:
61: BEGIN

Line 186: FROM fnd_lookup_values flv

182: --Transaction type for document type 'Receipt'
183: SELECT flv.lookup_code Tran_Type_Num
184: , flv.meaning Tran_Type_Name
185: , 'RECEIPT' Source
186: FROM fnd_lookup_values flv
187: WHERE flv.lookup_type = 'JA_CN_REC_TRAN_TYPE'
188: AND flv.language = USERENV('LANG')
189: UNION
190: --Transaction type for document type 'Payable'