DBA Data[Home] [Help]

APPS.AS_IMPORT_SL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 2402: from jtf_rs_resource_extns

2398:
2399: -- swkhanna 7/30/02 get assign_to_person_id if not being passed in table
2400: Cursor c_get_person_id (c_salesforce_id number) is
2401: select source_id
2402: from jtf_rs_resource_extns
2403: where resource_id = c_salesforce_id;
2404:
2405: l_assign_to_person_id number;
2406: l_validation_level number;

Line 4081: FROM JTF_RS_RESOURCE_EXTNS JS

4077: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
4078:
4079: CURSOR C_Get_SLAESFORCE(C_User_Id NUMBER) IS
4080: SELECT JS.RESOURCE_ID
4081: FROM JTF_RS_RESOURCE_EXTNS JS
4082: WHERE JS.USER_ID = C_User_Id;
4083:
4084: -- Cursor to select currency_code is passed null
4085: CURSOR C_currency_code (C_Terr_Code VARCHAR2) IS