850: ) return number is
851:
852: CURSOR c_parent_level_pk IS
853: select sr_parent_level_pk
854: from msd_level_associations
855: where
856: instance = p_instance_id and
857: level_id = p_level_id and
858: parent_level_id = p_parent_level_id and
899: ) return number is
900:
901: CURSOR c_child_level_pk IS
902: select sr_level_pk
903: from msd_level_associations
904: where
905: instance = p_instance_id and
906: level_id = p_level_id and
907: parent_level_id = p_parent_level_id and
1022: CURSOR c_count IS
1023: SELECT
1024: 1
1025: FROM
1026: msd_level_associations
1027: WHERE
1028: instance = p_instance
1029: and level_id = 1 -- item
1030: and sr_level_pk = p_inventory_item_id