APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on AS_SALES_LEADS

Line 102: p_sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,

98: p_resource_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
99: p_group_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
100: p_person_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
101: p_resource_flag_tbl IN AS_LEAD_ROUTING_WF.FLAG_TABLE,
102: p_sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
103: x_resource_id OUT NOCOPY NUMBER,
104: x_group_id OUT NOCOPY NUMBER,
105: x_person_id OUT NOCOPY NUMBER,
106: x_return_status OUT NOCOPY VARCHAR2,

Line 144: FROM AS_SALES_LEADS SL

140: WHERE res.resource_id = c_resource_id;
141:
142: CURSOR C_Get_Lead_Info(C_Sales_Lead_Id NUMBER) IS
143: SELECT SL.CUSTOMER_ID, SL.ADDRESS_ID
144: FROM AS_SALES_LEADS SL
145: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
146:
147: l_api_name CONSTANT VARCHAR2(30)
148: := 'Get_Owner_Pre';