APPS.PA_EXPENDITURE_GROUPS_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 430: select count(*) from pa_expenditure_items

426:
427: -- Check that expenditure items exist for the group
428: DECLARE
429: cursor count_ei is
430: select count(*) from pa_expenditure_items
431: where expenditure_id in
432: (select expenditure_id from pa_expenditures
433: where expenditure_group = x_expenditure_group);
434: x_count NUMBER;

Line 456: from pa_expenditure_items

452: where expenditure_group = x_expenditure_group;
453:
454: cursor totals is
455: select sum(quantity)
456: from pa_expenditure_items
457: where expenditure_id in
458: (select expenditure_id from pa_expenditures
459: where expenditure_group = x_expenditure_group);
460:

Line 495: select count(*) from pa_expenditure_items

491:
492: -- Make sure no quantities of null have been entered.
493: DECLARE
494: cursor null_qty is
495: select count(*) from pa_expenditure_items
496: where expenditure_id in (
497: select expenditure_id from pa_expenditures
498: where expenditure_group = x_expenditure_group )
499: and quantity is null ;