APPS.BIM_EDW_LEADS_F_SIZE dependencies on AS_SALES_LEAD_LINES

Line 15: FROM AS_SALES_LEAD_LINES ASLL,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AS_SALES_LEAD_LINES ASLL,
16: AS_SALES_LEADS ASL,
17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
18: BIM_EDW_LEADS_INC INC,
19: EDW_LOCAL_INSTANCE INST

Line 71: FROM AS_SALES_LEAD_LINES

67:
68: CURSOR c_1 IS
69: SELECT
70: avg(nvl(vsize( SALES_LEAD_LINE_ID ), 0))
71: FROM AS_SALES_LEAD_LINES
72: where last_update_date between
73: p_from_date and p_to_date;
74:
75: CURSOR c_2 IS