APPS.EGO_RULE_SETS_PKG dependencies on EGO_ONDEMAND_RULES_ITEMS_B

Line 916: l_batch_item_rec EGO_ONDEMAND_RULES_ITEMS_B%rowtype;

912: l_revision_id NUMBER DEFAULT NULL;
913: l_supplier_id NUMBER DEFAULT NULL;
914: l_supplier_site_id number default null;
915:
916: l_batch_item_rec EGO_ONDEMAND_RULES_ITEMS_B%rowtype;
917: CURSOR l_cursor_batch_items(p_batch NUMBER) IS
918: SELECT * FROM EGO_ONDEMAND_RULES_ITEMS_B WHERE batch_id = p_batch AND process_status = 1;
919:
920: CURSOR c_default_ag(p_data_level VARCHAR2, p_datalevel_id NUMBER, p_top_ruleset_id NUMBER, p_org_id NUMBER, p_inventory_item_id NUMBER, p_icc_id NUMBER) IS

Line 918: SELECT * FROM EGO_ONDEMAND_RULES_ITEMS_B WHERE batch_id = p_batch AND process_status = 1;

914: l_supplier_site_id number default null;
915:
916: l_batch_item_rec EGO_ONDEMAND_RULES_ITEMS_B%rowtype;
917: CURSOR l_cursor_batch_items(p_batch NUMBER) IS
918: SELECT * FROM EGO_ONDEMAND_RULES_ITEMS_B WHERE batch_id = p_batch AND process_status = 1;
919:
920: CURSOR c_default_ag(p_data_level VARCHAR2, p_datalevel_id NUMBER, p_top_ruleset_id NUMBER, p_org_id NUMBER, p_inventory_item_id NUMBER, p_icc_id NUMBER) IS
921: SELECT DISTINCT assoc.attr_group_id FROM EGO_OBJ_ATTR_GRP_ASSOCS_V assoc WHERE assoc.application_id = 431 AND assoc.classification_code = to_char(p_icc_id) AND assoc.data_level_int_name = p_data_level AND assoc.attr_group_id IN
922: (SELECT attr_group_id FROM ego_attr_groups_v WHERE attr_group_type = 'EGO_ITEMMGMT_GROUP' AND application_id = 431 AND attr_group_name IN (SELECT DISTINCT user_rules.attr_group_name FROM ego_user_rules_b user_rules