APPS.AS_ACCESS_PVT dependencies on AS_STATUSES_B

Line 1659: from as_leads_all ld, as_statuses_b st

1655: l_lead_rank_score number;
1656:
1657: cursor get_opp_open_flag_csr(pc_lead_id number) is
1658: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1659: from as_leads_all ld, as_statuses_b st
1660: where ld.lead_id = pc_lead_id
1661: and ld.status = st.status_code(+);
1662:
1663: cursor get_lead_open_flag_csr(pc_sales_lead_id number) is

Line 1665: from as_sales_leads ld, as_statuses_b st

1661: and ld.status = st.status_code(+);
1662:
1663: cursor get_lead_open_flag_csr(pc_sales_lead_id number) is
1664: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1665: from as_sales_leads ld, as_statuses_b st
1666: where ld.sales_lead_id = pc_sales_lead_id
1667: and ld.status_code = st.status_code(+);
1668:
1669: cursor get_lead_rank_score_csr(pc_sales_lead_id number) is