DBA Data[Home] [Help]

APPS.AS_OPPORTUNITY_PUB dependencies on PER_PEOPLE_F

Line 4715: Cursor C_GetPersonName(X_personID per_people_f.person_id%type)

4711: WHERE salesforce_id = X_SalesForceID
4712: AND lead_id = X_LeadID
4713: AND NVL(SALESGROUP_ID, -99) = NVL(X_salesGroupID, -99);
4714:
4715: Cursor C_GetPersonName(X_personID per_people_f.person_id%type)
4716: IS
4717: SELECT first_name||' '||last_name
4718: FROM per_people_f
4719: WHERE person_id = X_personID;

Line 4718: FROM per_people_f

4714:
4715: Cursor C_GetPersonName(X_personID per_people_f.person_id%type)
4716: IS
4717: SELECT first_name||' '||last_name
4718: FROM per_people_f
4719: WHERE person_id = X_personID;
4720:
4721: l_salesforce_id NUMBER;
4722: l_lead_id NUMBER;