[Home] [Help]
287: /* GL_LOOKUPS */
288: /* GL_USSGL_TRANSACTION_CODES */
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 */
2684: and ba.code_combination_id (+) = bp.code_combination_id
2685: and bo.range_id(+) = ba.range_id
2686: and bo.funding_budget_version_id
2687: in (select BV1.budget_version_id
2688: from gl_budget_versions bv1, gl_budgets b,
2689: gl_period_statuses ps
2690: where ba.ledger_id = g_ledger_id
2691: and ba.currency_code = bp.currency_code
2692: and ba.code_combination_id = bp.code_combination_id
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,
2871: gl_budorg_bc_options bo
3229: gl_summary_templates st,
3230: gl_account_hierarchies ah,
3231: gl_bc_packets bp,
3232: gl_summary_bc_options sb,
3233: gl_budgets b,
3234: gl_budget_versions bv,
3235: gl_period_statuses ps2
3236: where st.status = 'F'
3237: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3591: -- packet that need to be considered in this category include all rows
3592: -- with Funds Check Level None, and all Advisory Transactions with a
3593: -- lower rowid than that of the row currently being processed
3594:
3595: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3596: -- gl_period_statuses to get the last period in the latest open year of
3597: -- the Funding Budget for the Boundary Code 'project'
3598:
3599: -- Summary of WHERE clauses based on Amount Type and Boundary :
3665: 'CE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3666: 0)
3667: )
3668: from gl_period_statuses ps,
3669: gl_budgets bd,
3670: gl_budget_versions bv,
3671: gl_bc_packets pk,
3672: gl_bc_packet_arrival_order ao
3673: where ps.application_id = 101
8969: GL_BC_PACKETS BP,
8970: GL_BC_PACKET_ARRIVAL_ORDER AO,
8971: GL_SUMMARY_TEMPLATES ST,
8972: GL_SUMMARY_BC_OPTIONS SB,
8973: GL_BUDGETS B,
8974: GL_BUDGET_VERSIONS BV,
8975: GL_PERIOD_STATUSES PS
8976:
8977: WHERE
9118: GL_BC_PACKETS BP,
9119: GL_BC_PACKET_ARRIVAL_ORDER AO,
9120: GL_SUMMARY_TEMPLATES ST,
9121: GL_SUMMARY_BC_OPTIONS SB,
9122: GL_BUDGETS B,
9123: GL_BUDGET_VERSIONS BV,
9124: GL_PERIOD_STATUSES PS
9125: WHERE AH.ledger_id = p_ledger_id
9126: AND AH.detail_code_combination_id = BP.code_combination_id
9233: gl_account_hierarchies ah,
9234: gl_bc_packet_arrival_order ao,
9235: gl_summary_templates st,
9236: gl_summary_bc_options sb,
9237: gl_budgets b,
9238: gl_budget_versions bv,
9239: gl_period_statuses ps
9240: WHERE ah.ledger_id = p_ledger_id
9241: AND ah.template_id = p_curr_temp_id