884: FUNCTION child_supplies_onhand(p_plan_id number,
885: p_transaction_id number) return number IS
886: CURSOR child_supply_c is
887: SELECT 1
888: from msc_full_pegging mfp1,
889: msc_full_pegging mfp2,
890: msc_supplies ms
891: where mfp1.plan_id = p_plan_id
892: and mfp1.transaction_id = p_transaction_id
885: p_transaction_id number) return number IS
886: CURSOR child_supply_c is
887: SELECT 1
888: from msc_full_pegging mfp1,
889: msc_full_pegging mfp2,
890: msc_supplies ms
891: where mfp1.plan_id = p_plan_id
892: and mfp1.transaction_id = p_transaction_id
893: and mfp2.plan_id = mfp1.plan_id