APPS.PA_EFC_BIL dependencies on PA_PROJECT_FUNDINGS

Line 25: FROM pa_project_fundings f

21: pl_task_id NUMBER,
22: pl_agreement_id NUMBER) IS
23: SELECT f.budget_type_code budget_type_code,
24: NVL(SUM(f.allocated_amount),0) tot_amt
25: FROM pa_project_fundings f
26: WHERE f.project_id = pl_project_id
27: AND f.agreement_id = pl_agreement_id
28: AND nvl(f.task_id,-99) = nvl(pl_task_id,-99)
29: GROUP BY f.budget_type_code;

Line 157: FROM pa_project_fundings f

153: -- get the latest funding id to update the adjusted amount
154:
155: CURSOR cur_adj IS
156: SELECT f.project_funding_id project_funding_id
157: FROM pa_project_fundings f
158: WHERE f.project_id = p_project_id
159: AND f.agreement_id = p_agreement_id
160: AND NVL(f.task_id,-99)= NVL(p_task_id,-99)
161: AND f.budget_type_code = 'BASELINE'

Line 177: UPDATE pa_project_fundings pf

173: EXIT WHEN cur_adj%NOTFOUND;
174:
175: -- update the Project Funding record
176:
177: UPDATE pa_project_fundings pf
178: SET pf.allocated_amount=(pf.allocated_amount+p_adjusted)
179: WHERE pf.project_funding_id = rec_adj.project_funding_id;
180:
181: -- update the Project Funding EFC record

Line 183: UPDATE pa_project_fundings_efc pfefc

179: WHERE pf.project_funding_id = rec_adj.project_funding_id;
180:
181: -- update the Project Funding EFC record
182:
183: UPDATE pa_project_fundings_efc pfefc
184: SET pfefc.adjusted_amount=p_adjusted
185: WHERE pfefc.project_funding_id = rec_adj.project_funding_id;
186:
187: update_flag := TRUE;