[Home] [Help]
2682: and b.budget_name = bv1.budget_name
2683: and ((b.budget_type = 'payment'
2684: and bp.actual_flag in ('P', 'F'))
2685: or
2686: (b.budget_type = 'standard'
2687: and bp.actual_flag not in ('P', 'F')))
2688: and ps.application_id = 101
2689: and ps.ledger_id = g_ledger_id
2690: and ps.period_name = bp.period_name
2869: and bv.budget_name = b.budget_name
2870: and ((b.budget_type = 'payment' and
2871: pk.actual_flag IN ('P', 'F'))
2872: or
2873: (b.budget_type = 'standard' and
2874: pk.actual_flag not in ('P', 'F')))
2875: and ps.application_id = 101
2876: and ps.ledger_id = g_ledger_id
2877: and ps.period_name = pk.period_name
3235: AND SB.template_id = ST.template_id
3236: AND SB.funding_budget_version_id = BV.budget_version_id
3237: AND BV.budget_name = B.budget_name
3238: AND ((BV.budget_type = 'payment' AND BP.actual_flag in ('P', 'F'))
3239: OR (BV.budget_type = 'standard' AND BP.actual_flag in ('A', 'E'))
3240: OR (BP.actual_flag = 'B'))
3241: and ps2.ledger_id = g_ledger_id
3242: and ps2.application_id = 101
3243: AND PS2.period_name = BP.period_name
5149: --
5150: -- glrchk() provides this centralize place to callout to these other parties.
5151: --
5152: -- Bug 2184578
5153: -- If Standard Budgetary Control failed, CBC Journals shoud not be committed.
5154: -- This is achieved by calling function IGC_CBC_GL_FC_PKG.reconcile_glzcbc
5155: --
5156:
5157: FUNCTION glrchk(post_control IN gl_bc_packets.result_code%TYPE)