APPS.PV_ASSIGN_UTIL_PVT dependencies on AS_STATUSES_B

Line 1749: from as_leads_all ld, as_statuses_b st

1745: AND pn.notification_type = 'OFFERED_TO';
1746:
1747: cursor get_opp_open_flag_csr(pc_lead_id number) is
1748: select decode(st.opp_open_status_flag,'N',NULL,st.opp_open_status_flag)
1749: from as_leads_all ld, as_statuses_b st
1750: where ld.lead_id = pc_lead_id
1751: and ld.status = st.status_code;
1752:
1753: l_current_user_rs_id NUMBER; -- resource_id of currently logged in user