DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_FULL_PEGGING

Line 888: from msc_full_pegging mfp1,

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

Line 889: msc_full_pegging mfp2,

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