APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_ACT_BUDGETS

Line 144: FROM ozf_act_budgets a1

140: SELECT SUM (amount) total_amount
141: FROM(
142: SELECT --- request amount
143: NVL (SUM (a1.approved_amount), 0) amount
144: FROM ozf_act_budgets a1
145: WHERE a1.act_budget_used_by_id = p_object_id
146: AND a1.arc_act_budget_used_by = p_object_type
147: AND a1.budget_source_type = 'FUND'
148: AND a1.budget_source_id = p_budget_source_id

Line 153: FROM ozf_act_budgets a2

149: AND a1.status_code = 'APPROVED'
150: AND a1.transfer_type ='REQUEST'
151: UNION
152: SELECT -NVL (SUM (a2.approved_original_amount), 0) amount
153: FROM ozf_act_budgets a2
154: WHERE a2.budget_source_id = p_object_id
155: AND a2.budget_source_type = p_object_type
156: AND a2.act_budget_used_by_id = p_budget_source_id
157: AND a2.arc_act_budget_used_by = 'FUND'

Line 776: FROM ozf_act_budgets a1

772: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
773: CURSOR c_obj_amount IS
774: SELECT SUM (amount) amount FROM (
775: SELECT DECODE(a1.status_code ,'NEW',a1.request_amount,'APPROVED', a1.approved_amount,0) amount
776: FROM ozf_act_budgets a1
777: WHERE a1.act_budget_used_by_id = p_object_id
778: AND a1.arc_act_budget_used_by = p_object_type
779: AND a1.transfer_type = 'REQUEST'
780: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)

Line 784: FROM ozf_act_budgets a1

780: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)
781: AND status_code <> 'REJECTED'
782: UNION ALL
783: SELECT DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount) amount
784: FROM ozf_act_budgets a1
785: WHERE a1.budget_source_id = p_object_id
786: AND a1.budget_source_type = p_object_type
787: AND a1.transfer_type = 'TRANSFER'
788: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)

Line 801: FROM ozf_act_budgets a1

797: 'TRANSFER' ,
798: DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount))
799: ,0)
800: ) amount
801: FROM ozf_act_budgets a1
802: WHERE DECODE(a1.transfer_type , 'REQUEST', a1.act_budget_used_by_id, 'TRANSFER' , a1.budget_source_id ) = p_object_id
803: AND DECODE(a1.transfer_type , 'REQUEST', a1.arc_act_budget_used_by, 'TRANSFER' , a1.budget_source_type ) = p_object_type
804: AND a1.transfer_type <> 'UTILIZED'
805: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)

Line 812: FROM ozf_act_budgets a1

808: -- 5/10/2002 mpande commented the code
809: /*
810: CURSOR c_obj_amount IS
811: SELECT NVL (SUM (NVL (a1.approved_amount, a1.request_amount)), 0) amount
812: FROM ozf_act_budgets a1
813: WHERE a1.act_budget_used_by_id = p_object_id
814: AND a1.arc_act_budget_used_by = p_object_type
815: AND a1.transfer_type <> 'UTILIZED'
816: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)