DBA Data[Home] [Help]

APPS.GLR03300_PKG dependencies on GL_LOOKUPS

Line 136: FROM gl_lookups

132:
133: CURSOR c_show_batch_stat (lv_je_header_id gl_je_headers.je_header_id%type ,
134: lv_status gl_je_batches.status%type ) IS
135: SELECT description
136: FROM gl_lookups
137: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'MJE_BATCH_STATUS')
138: AND lookup_code=substr( lv_status , 1 , 1);
139:
140:

Line 144: FROM gl_lookups

140:
141: CURSOR c_show_bc_stat (lv_je_header_id gl_je_headers.je_header_id%type ,
142: lv_status gl_je_batches.budgetary_control_status%type ) IS
143: SELECT meaning
144: FROM gl_lookups
145: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'JE_BATCH_BC_STATUS')
146: AND lookup_code= lv_status ;
147:
148: CURSOR c1 (lv_je_batch_id gl_je_headers.je_batch_id%type ) IS