APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_SALES_LEAD_RANKS_B

Line 3862: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

3858: -- Get lead_rank_score and lead creation_date
3859: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
3860: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
3861: NVL(rk.min_score, 0), sl.creation_date
3862: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
3863: WHERE sl.sales_lead_id = c_sales_lead_id
3864: AND sl.status_code = sta.status_code
3865: AND sl.lead_rank_id = rk.rank_id(+);
3866: BEGIN

Line 4163: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4159: -- Get lead_rank_score and lead creation_date
4160: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4161: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4162: NVL(rk.min_score, 0), sl.creation_date
4163: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4164: WHERE sl.sales_lead_id = c_sales_lead_id
4165: AND sl.status_code = sta.status_code
4166: AND sl.lead_rank_id = rk.rank_id(+);
4167:

Line 4376: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4372: -- Get lead_rank_score and lead creation_date
4373: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4374: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4375: NVL(rk.min_score, 0), sl.creation_date
4376: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4377: WHERE sl.sales_lead_id = c_sales_lead_id
4378: AND sl.status_code = sta.status_code
4379: AND sl.lead_rank_id = rk.rank_id(+);
4380: BEGIN

Line 4749: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4745: -- Get lead_rank_score and lead creation_date
4746: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4747: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4748: NVL(rk.min_score, 0), sl.creation_date
4749: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4750: WHERE sl.sales_lead_id = c_sales_lead_id
4751: AND sl.status_code = sta.status_code
4752: AND sl.lead_rank_id = rk.rank_id(+);
4753: BEGIN

Line 5049: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5045: -- Get lead_rank_score and lead creation_date
5046: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5047: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5048: NVL(rk.min_score, 0), sl.creation_date
5049: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5050: WHERE sl.sales_lead_id = c_sales_lead_id
5051: AND sl.status_code = sta.status_code
5052: AND sl.lead_rank_id = rk.rank_id(+);
5053:

Line 5914: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5910: -- Get lead_rank_score and lead creation_date
5911: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5912: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5913: NVL(rk.min_score, 0), sl.creation_date
5914: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5915: WHERE sl.sales_lead_id = c_sales_lead_id
5916: AND sl.status_code = sta.status_code
5917: AND sl.lead_rank_id = rk.rank_id(+);
5918: BEGIN