DBA Data[Home] [Help]

APPS.OZF_GL_TRANSFER_PVT dependencies on FND_LOOKUPS

Line 97: from fnd_lookups

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

Line 103: FROM fnd_lookups l, fnd_product_installations i

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;