93: where JE_CATEGORY_NAME = je_name;
94:
95: CURSOR lookup_name_csr (lk_type VARCHAR2, lk_code VARCHAR2) IS
96: SELECT meaning
97: from fnd_lookups
98: where lookup_type = lk_type
99: and lookup_code = lk_code;
100:
101: CURSOR submit_jrnl_import_csr (lk_type VARCHAR2, lk_code VARCHAR2) IS
99: and lookup_code = lk_code;
100:
101: CURSOR submit_jrnl_import_csr (lk_type VARCHAR2, lk_code VARCHAR2) IS
102: SELECT l.meaning
103: FROM fnd_lookups l, fnd_product_installations i
104: WHERE l.lookup_type = lk_type
105: AND i.application_id = 101
106: AND (i.status = 'I' or (i.status = 'S' and l.lookup_code = 'N'))
107: AND l.lookup_code = lk_code;