eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_LEAD_RANKS_B

Line 1338: FROM as_sales_lead_ranks_b

1334: )
1335: IS
1336: CURSOR C_Rank_Exists (X_Rank_id NUMBER) IS
1337: SELECT 'X'
1338: FROM as_sales_lead_ranks_b
1339: WHERE rank_id = X_Rank_id
1340: and enabled_flag = 'Y';
1341: l_val VARCHAR2(1);
1342: BEGIN

Line 3309: FROM as_sales_lead_ranks_b

3305:
3306:
3307: CURSOR C_Get_Lead_Rank_Score (X_Rank_ID NUMBER) IS
3308: SELECT min_score
3309: FROM as_sales_lead_ranks_b
3310: WHERE rank_id = X_Rank_ID;
3311:
3312:
3313: -- 11.5.10 ckapoor Lead Name changes for Rivendell

Line 4386: FROM as_sales_lead_ranks_b

4382: and status_code = X_Lookup_Code;
4383:
4384: CURSOR C_Get_Lead_Rank_Score (X_Rank_ID NUMBER) IS
4385: SELECT min_score
4386: FROM as_sales_lead_ranks_b
4387: WHERE rank_id = X_Rank_ID;
4388:
4389: -- End denorm fix 2928041
4390:

Line 4471: FROM as_sales_lead_ranks_b

4467: ORDER BY log_id DESC;
4468:
4469: CURSOR C_get_rank_score (c_lead_rank_id NUMBER) IS
4470: SELECT min_score
4471: FROM as_sales_lead_ranks_b
4472: WHERE rank_id = c_lead_rank_id;
4473:
4474: -- ckapoor 11.5.10 bug 3225643 cursor to find salesgroup id given the salesforce id
4475: