DBA Data[Home] [Help]

APPS.GL_SUMMARY_BC_OPTIONS_PKG dependencies on GL_LOOKUPS

Line 201: FROM GL_LOOKUPS

197: ) IS
198:
199: CURSOR check_funds_check_level IS
200: SELECT 'X'
201: FROM GL_LOOKUPS
202: WHERE LOOKUP_TYPE = 'FUNDS_CHECK_LEVEL'
203: AND lookup_code = X_Funds_Check_Level_Code;
204:
205: CURSOR check_amount_type IS

Line 207: FROM GL_LOOKUPS_AMOUNT_TYPES_V

203: AND lookup_code = X_Funds_Check_Level_Code;
204:
205: CURSOR check_amount_type IS
206: SELECT 'X'
207: FROM GL_LOOKUPS_AMOUNT_TYPES_V
208: WHERE amount_type = X_Amount_Type;
209:
210: CURSOR check_boundary_code IS
211: SELECT 'X'

Line 212: FROM GL_LOOKUPS_BOUNDARIES_V

208: WHERE amount_type = X_Amount_Type;
209:
210: CURSOR check_boundary_code IS
211: SELECT 'X'
212: FROM GL_LOOKUPS_BOUNDARIES_V
213: WHERE boundary_code = X_Boundary_Code;
214:
215: CURSOR check_budget_version IS
216: SELECT 'X'

Line 222: FROM GL_LOOKUPS

218: WHERE budget_version_id = X_Funding_Budget_Version_Id;
219:
220: CURSOR check_dr_cr_code IS
221: SELECT 'X'
222: FROM GL_LOOKUPS
223: WHERE LOOKUP_TYPE = 'DR_CR'
224: AND lookup_code = X_Dr_Cr_Code;
225:
226: L_Budgetary_Control_Flag VARCHAR2(1);