7350: RETVAL BOOLEAN := TRUE;
7351:
7352: CURSOR C_ORG IS
7353: SELECT 1 7354: FROM fm_matl_dtl d 7355: WHERE inventory_item_id = p_itemID
7356: AND organization_id = p_orgID
7357: AND EXISTS
7358: (
Line 7368: FROM fm_matl_dtl d
7364: AND ROWNUM = 1;
7365:
7366: CURSOR C_MASTER IS
7367: SELECT 1 7368: FROM fm_matl_dtl d 7369: WHERE d.inventory_item_id = p_itemID
7370: AND EXISTS
7371: (
7372: SELECT 1