APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on PV_CHANNEL_TYPES

Line 175: FROM pv_channel_types channel

171:
172: -- Retrieve channel type
173: CURSOR c_get_indirect_channel_flag(c_channel_code VARCHAR2) IS
174: SELECT NVL(channel.indirect_channel_flag, 'N')
175: FROM pv_channel_types channel
176: WHERE channel.channel_lookup_code = c_channel_code;
177:
178: l_api_name CONSTANT VARCHAR2(30)
179: := 'Run_Lead_Engines';

Line 1065: FROM pv_process_rules_b rule, pv_channel_types channel

1061: -- Retrieve channel selection criteria for the rule
1062: CURSOR c_get_channel_criterion_rule(c_process_rule_id NUMBER) IS
1063: SELECT rule.process_rule_id, rule.action, rule.action_value,
1064: NVL(channel.rank, 0)
1065: FROM pv_process_rules_b rule, pv_channel_types channel
1066: WHERE rule.parent_rule_id = c_process_rule_id
1067: AND channel.channel_lookup_code(+) = rule.action_value
1068: ORDER BY rule.rank;
1069:

Line 3124: FROM pv_channel_types channel

3120:
3121: -- Retrieve channel type
3122: CURSOR c_get_indirect_channel_flag(c_channel_code VARCHAR2) IS
3123: SELECT NVL(channel.indirect_channel_flag, 'N')
3124: FROM pv_channel_types channel
3125: WHERE channel.channel_lookup_code = c_channel_code;
3126:
3127: -- Check whether owner exists or not
3128: CURSOR c_check_owner_exists(c_sales_lead_id NUMBER) IS