APPS.AML_PURGE_SALES_LEADS dependencies on FND_PROFILE

Line 179: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')

175: SELECT Sales_Lead_Id
176: FROM As_sales_leads
177: WHERE Qualified_Flag = 'N'
178: AND TRUNC(Creation_Date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
179: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')
180: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');
181:
182: BEGIN
183: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');

Line 180: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');

176: FROM As_sales_leads
177: WHERE Qualified_Flag = 'N'
178: AND TRUNC(Creation_Date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
179: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')
180: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');
181:
182: BEGIN
183: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
184: l_end_date := to_date(p_end_date, 'YYYY/MM/DD HH24:MI:SS');

Line 229: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')

225: INTO Id_Tab
226: FROM AS_SALES_LEADS
227: WHERE Qualified_Flag = 'N'
228: AND TRUNC(Creation_Date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
229: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')
230: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');
231:
232: IF Id_Tab.FIRST IS NOT NULL THEN --This should be executed only if atleast there is one record.
233: Delete_Unqualified_Leads(Id_Tab);

Line 230: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');

226: FROM AS_SALES_LEADS
227: WHERE Qualified_Flag = 'N'
228: AND TRUNC(Creation_Date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
229: AND status_code <> fnd_profile.value('AS_LEAD_LINK_STATUS')
230: AND status_code = fnd_profile.value('AS_DEFAULT_LEAD_STATUS');
231:
232: IF Id_Tab.FIRST IS NOT NULL THEN --This should be executed only if atleast there is one record.
233: Delete_Unqualified_Leads(Id_Tab);
234: END IF;