APPS.GLR03300_PKG dependencies on GL_JE_BATCHES

Line 134: lv_status gl_je_batches.status%type ) IS

130: FROM gl_daily_conversion_types
131: WHERE conversion_type = lv_curr_conv_type ;
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);

Line 142: lv_status gl_je_batches.budgetary_control_status%type ) IS

138: AND lookup_code=substr( lv_status , 1 , 1);
139:
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 ;

Line 149: select status,budgetary_control_status from gl_je_batches where

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
149: select status,budgetary_control_status from gl_je_batches where
150: je_batch_id=lv_je_batch_id ;
151:
152:
153: lv_header c_header%rowtype;