APPS.PA_FP_OF_WEBADI_PKG dependencies on PA_FP_OF_WEBADI_V

Line 205: FROM PA_FP_OF_WEBADI_V;

201:
202:
203: CURSOR C1 IS
204: SELECT distinct category_id
205: FROM PA_FP_OF_WEBADI_V;
206:
207: CURSOR C2(l_category_id number) IS
208: SELECT distinct Other_Organization_Id
209: FROM PA_FP_OF_WEBADI_V

Line 209: FROM PA_FP_OF_WEBADI_V

205: FROM PA_FP_OF_WEBADI_V;
206:
207: CURSOR C2(l_category_id number) IS
208: SELECT distinct Other_Organization_Id
209: FROM PA_FP_OF_WEBADI_V
210: Where category_id = l_category_id;
211:
212: CURSOR C3(l_category_id number,l_other_org_id number) IS
213: SELECT

Line 279: FROM PA_FP_OF_WEBADI_V

275: Period49,
276: Period50,
277: Period51,
278: Period52
279: FROM PA_FP_OF_WEBADI_V
280: Where Category_id = l_category_id
281: and Other_Organization_Id =l_other_org_id;
282:
283: BEGIN

Line 642: From PA_FP_OF_WEBADI_V

638: l_org_tot_period49,
639: l_org_tot_period50,
640: l_org_tot_period51,
641: l_org_tot_period52
642: From PA_FP_OF_WEBADI_V
643: Where category_id = l_category_id
644: And Other_Organization_Id = l_other_org_id;
645:
646:

Line 945: From PA_FP_OF_WEBADI_V

941: l_cat_tot_period49,
942: l_cat_tot_period50,
943: l_cat_tot_period51,
944: l_cat_tot_period52
945: From PA_FP_OF_WEBADI_V
946: Where category_id = l_category_id;
947:
948: --dbms_output.put_line('done calculating cat total');
949: