APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_ACT_BUDGETS

Line 141: FROM ozf_act_budgets a1

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

Line 150: FROM ozf_act_budgets a2

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

Line 770: FROM ozf_act_budgets a1

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

Line 778: FROM ozf_act_budgets a1

774: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)
775: AND status_code <> 'REJECTED'
776: UNION ALL
777: SELECT DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount) amount
778: FROM ozf_act_budgets a1
779: WHERE a1.budget_source_id = p_object_id
780: AND a1.budget_source_type = p_object_type
781: AND a1.transfer_type = 'TRANSFER'
782: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)

Line 795: FROM ozf_act_budgets a1

791: 'TRANSFER' ,
792: DECODE(a1.status_code ,'NEW',a1.src_curr_request_amt,'APPROVED', -a1.approved_original_amount))
793: ,0)
794: ) amount
795: FROM ozf_act_budgets a1
796: WHERE DECODE(a1.transfer_type , 'REQUEST', a1.act_budget_used_by_id, 'TRANSFER' , a1.budget_source_id ) = p_object_id
797: AND DECODE(a1.transfer_type , 'REQUEST', a1.arc_act_budget_used_by, 'TRANSFER' , a1.budget_source_type ) = p_object_type
798: AND a1.transfer_type <> 'UTILIZED'
799: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)

Line 806: FROM ozf_act_budgets a1

802: -- 5/10/2002 mpande commented the code
803: /*
804: CURSOR c_obj_amount IS
805: SELECT NVL (SUM (NVL (a1.approved_amount, a1.request_amount)), 0) amount
806: FROM ozf_act_budgets a1
807: WHERE a1.act_budget_used_by_id = p_object_id
808: AND a1.arc_act_budget_used_by = p_object_type
809: AND a1.transfer_type <> 'UTILIZED'
810: AND a1.activity_budget_id <> NVL (p_act_budget_id, 0)