[Home] [Help]
2693: and b.budget_name = bv1.budget_name
2694: and ((b.budget_type = 'payment'
2695: and bp.actual_flag in ('P', 'F'))
2696: or
2697: (b.budget_type = 'standard'
2698: and bp.actual_flag not in ('P', 'F')))
2699: and ps.application_id = 101
2700: and ps.ledger_id = g_ledger_id
2701: and ps.period_name = bp.period_name
2880: and bv.budget_name = b.budget_name
2881: and ((b.budget_type = 'payment' and
2882: pk.actual_flag IN ('P', 'F'))
2883: or
2884: (b.budget_type = 'standard' and
2885: pk.actual_flag not in ('P', 'F')))
2886: and ps.application_id = 101
2887: and ps.ledger_id = g_ledger_id
2888: and ps.period_name = pk.period_name
3248: AND SB.template_id = ST.template_id
3249: AND SB.funding_budget_version_id = BV.budget_version_id
3250: AND BV.budget_name = B.budget_name
3251: AND ((BV.budget_type = 'payment' AND BP.actual_flag in ('P', 'F'))
3252: OR (BV.budget_type = 'standard' AND BP.actual_flag in ('A', 'E'))
3253: OR (BP.actual_flag = 'B'))
3254: and ps2.ledger_id = g_ledger_id
3255: and ps2.application_id = 101
3256: AND PS2.period_name = BP.period_name
5224: --
5225: -- glrchk() provides this centralize place to callout to these other parties.
5226: --
5227: -- Bug 2184578
5228: -- If Standard Budgetary Control failed, CBC Journals shoud not be committed.
5229: -- This is achieved by calling function IGC_CBC_GL_FC_PKG.reconcile_glzcbc
5230: --
5231:
5232: FUNCTION glrchk(post_control IN gl_bc_packets.result_code%TYPE)