APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on AS_SALES_LEAD_RANKS_B

Line 1056: FROM pv_process_rules_b rule, as_sales_lead_ranks_b rank

1052: -- Retrieve rating criteria for the rule
1053: CURSOR c_get_rating_criterion_rule(c_process_rule_id NUMBER) IS
1054: SELECT rule.process_rule_id, rule.action, rule.action_value,
1055: rank.min_score
1056: FROM pv_process_rules_b rule, as_sales_lead_ranks_b rank
1057: WHERE rule.parent_rule_id = c_process_rule_id
1058: AND rank.rank_id = TO_NUMBER(rule.action_value)
1059: ORDER BY rule.rank;
1060:

Line 1094: FROM as_sales_lead_ranks_b

1090:
1091: -- Get rank score
1092: CURSOR c_get_rank_score(c_rank_id NUMBER) IS
1093: SELECT NVL(min_score, 0)
1094: FROM as_sales_lead_ranks_b
1095: WHERE rank_id = c_rank_id;
1096:
1097: -- ckapoor 11.5.10 Winning rule logging project : Cursor to get all the attributes
1098: -- for the winning rule