APPS.AS_SALES_LEADS_PVT dependencies on AS_STATUSES_B

Line 820: FROM as_statuses_b

816: )
817: IS
818: CURSOR C_Status_Exists (X_Lookup_Code VARCHAR2) IS
819: SELECT 'X'
820: FROM as_statuses_b
821: WHERE lead_flag = 'Y' and enabled_flag = 'Y'
822: and status_code = X_Lookup_Code;
823: -- ffang 012501, add more criteria
824: -- sync up with validation used in status dropdown

Line 1812: FROM as_statuses_b

1808: )
1809: IS
1810: CURSOR C_Status_Exists (X_Lookup_Code VARCHAR2) IS
1811: SELECT opp_open_status_flag
1812: FROM as_statuses_b
1813: WHERE lead_flag = 'Y' and enabled_flag = 'Y'
1814: and status_code = X_Lookup_Code;
1815: l_val VARCHAR2(1);
1816: l_profile_opp_lead_link VARCHAR2(200);

Line 3301: FROM as_statuses_b

3297:
3298:
3299: CURSOR C_Get_Status_open_flag(X_Lookup_Code VARCHAR2) IS
3300: SELECT opp_open_status_flag
3301: FROM as_statuses_b
3302: WHERE lead_flag = 'Y' and enabled_flag = 'Y'
3303: and status_code = X_Lookup_Code;
3304:
3305:

Line 4380: FROM as_statuses_b

4376: -- Denorm fix 2928041
4377:
4378: CURSOR C_Get_Status_open_flag(X_Lookup_Code VARCHAR2) IS
4379: SELECT opp_open_status_flag
4380: FROM as_statuses_b
4381: WHERE lead_flag = 'Y' and enabled_flag = 'Y'
4382: and status_code = X_Lookup_Code;
4383:
4384: CURSOR C_Get_Lead_Rank_Score (X_Rank_ID NUMBER) IS