[Home] [Help]
289: /* GL_USSGL_ACCOUNT_PAIRS */
290: /* GL_BALANCES */
291: /* GL_BUDGETS */
292: /* GL_BUDGET_VERSIONS */
293: /* GL_BUDGET_ASSIGNMENTS */
294: /* GL_BUDGET_PERIOD_RANGES */
295: /* GL_JE_BATCHES */
296: /* GL_JE_HEADERS */
297: /* GL_JE_LINES */
2672: g_session_id,
2673: g_serial_id,
2674: g_resp_appl_id
2675: from psa_option_details_gt od,
2676: gl_budget_assignments ba,
2677: gl_bc_packets bp,
2678: gl_budorg_bc_options bo
2679: where (od.je_source_name || ';' || od.je_category_name =
2680: bp.je_source_name || ';' ||bp.je_category_name )
2862: update gl_bc_packets bp
2863: set bp.funding_budget_version_id =
2864: (select decode(pk.actual_flag, 'B', pk.budget_version_id,
2865: bo.funding_budget_version_id)
2866: from gl_budget_assignments ba,
2867: gl_budgets b,
2868: gl_budget_versions bv,
2869: gl_period_statuses ps,
2870: gl_bc_packets pk,
2917: RESULT_CODE=
2918: ( select DECODE(count(bo.FUNDING_BUDGET_VERSION_ID),1,'F77','F80')
2919: from
2920: gl_bc_packets pk,
2921: gl_budget_assignments ba,
2922: gl_budorg_bc_options bo
2923: where
2924: pk.rowid=bp.rowid
2925: and pk.code_combination_id=ba.code_combination_id
3050: min(bo.amount_type),
3051: min(bo.boundary_code)
3052: from gl_bc_packets pk,
3053: psa_option_details_gt od,
3054: gl_budget_assignments ba,
3055: gl_budorg_bc_options bo
3056: where pk.rowid = bp.rowid
3057: and (od.je_source_name || ';' || od.je_category_name =
3058: pk.je_source_name || ';' || pk.je_category_name )
3088: and bp.funds_check_level_code = 'N'
3089: and bp.funding_budget_version_id IS NULL
3090: and exists
3091: (select null
3092: from gl_budget_assignments ba
3093: where ba.code_combination_id = bp.code_combination_id
3094: and ba.ledger_id = bp.ledger_id
3095: and ba.currency_code = bp.currency_code
3096: