[Home] [Help]
276: /* GL_LOOKUPS */
277: /* GL_USSGL_TRANSACTION_CODES */
278: /* GL_USSGL_ACCOUNT_PAIRS */
279: /* GL_BALANCES */
280: /* GL_BUDGETS */
281: /* GL_BUDGET_VERSIONS */
282: /* GL_BUDGET_ASSIGNMENTS */
283: /* GL_BUDGET_PERIOD_RANGES */
284: /* GL_JE_BATCHES */
2673: and ba.code_combination_id (+) = bp.code_combination_id
2674: and bo.range_id(+) = ba.range_id
2675: and bo.funding_budget_version_id
2676: in (select BV1.budget_version_id
2677: from gl_budget_versions bv1, gl_budgets b,
2678: gl_period_statuses ps
2679: where ba.ledger_id = g_ledger_id
2680: and ba.currency_code = bp.currency_code
2681: and ba.code_combination_id = bp.code_combination_id
2852: set bp.funding_budget_version_id =
2853: (select decode(pk.actual_flag, 'B', pk.budget_version_id,
2854: bo.funding_budget_version_id)
2855: from gl_budget_assignments ba,
2856: gl_budgets b,
2857: gl_budget_versions bv,
2858: gl_period_statuses ps,
2859: gl_bc_packets pk,
2860: gl_budorg_bc_options bo
3216: gl_summary_templates st,
3217: gl_account_hierarchies ah,
3218: gl_bc_packets bp,
3219: gl_summary_bc_options sb,
3220: gl_budgets b,
3221: gl_budget_versions bv,
3222: gl_period_statuses ps2
3223: where st.status = 'F'
3224: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3517: -- packet that need to be considered in this category include all rows
3518: -- with Funds Check Level None, and all Advisory Transactions with a
3519: -- lower rowid than that of the row currently being processed
3520:
3521: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3522: -- gl_period_statuses to get the last period in the latest open year of
3523: -- the Funding Budget for the Boundary Code 'project'
3524:
3525: -- Summary of WHERE clauses based on Amount Type and Boundary :
3591: 'CE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3592: 0)
3593: )
3594: from gl_period_statuses ps,
3595: gl_budgets bd,
3596: gl_budget_versions bv,
3597: gl_bc_packets pk,
3598: gl_bc_packet_arrival_order ao
3599: where ps.application_id = 101
8783: GL_BC_PACKETS BP,
8784: GL_BC_PACKET_ARRIVAL_ORDER AO,
8785: GL_SUMMARY_TEMPLATES ST,
8786: GL_SUMMARY_BC_OPTIONS SB,
8787: GL_BUDGETS B,
8788: GL_BUDGET_VERSIONS BV,
8789: GL_PERIOD_STATUSES PS
8790:
8791: WHERE
8932: GL_BC_PACKETS BP,
8933: GL_BC_PACKET_ARRIVAL_ORDER AO,
8934: GL_SUMMARY_TEMPLATES ST,
8935: GL_SUMMARY_BC_OPTIONS SB,
8936: GL_BUDGETS B,
8937: GL_BUDGET_VERSIONS BV,
8938: GL_PERIOD_STATUSES PS
8939: WHERE AH.ledger_id = p_ledger_id
8940: AND AH.detail_code_combination_id = BP.code_combination_id
9047: gl_account_hierarchies ah,
9048: gl_bc_packet_arrival_order ao,
9049: gl_summary_templates st,
9050: gl_summary_bc_options sb,
9051: gl_budgets b,
9052: gl_budget_versions bv,
9053: gl_period_statuses ps
9054: WHERE ah.ledger_id = p_ledger_id
9055: AND ah.template_id = p_curr_temp_id