DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on PER_PEOPLE_F

Line 402: l_display_name per_people_f.full_name%type;

398:
399: l_role_name VARCHAR2(30):= 'AR_CMGT_CREDIT_ANALYST_ROLE';
400: l_role_display_name VARCHAR2(240) := 'Credit Analyst Role';
401: l_user_name fnd_user.user_name%type;
402: l_display_name per_people_f.full_name%type;
403:
404: CURSOR c_get_resource_id IS
405: SELECT c.resource_id, c.source_id --employee id
406: FROM jtf_rs_role_relations a,

Line 881: l_employee_id per_people_f.person_id%type;

877: l_user_name VARCHAR2(60);
878: l_display_name VARCHAR2(240);
879: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
880: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;
881: l_employee_id per_people_f.person_id%type;
882: l_dummy VARCHAR2(1);
883: BEGIN
884: IF funcmode = 'RUN'
885: THEN

Line 1410: l_requestor_display_name per_people_f.full_name%type;

1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;

Line 3756: l_person_id per_people_f.person_id%type;

3752: p_attribute_type IN VARCHAR2,
3753: p_attribute_name IN VARCHAR2,
3754: p_attribute_value IN VARCHAR2 ) IS
3755:
3756: l_person_id per_people_f.person_id%type;
3757: l_user_name VARCHAR2(60);
3758: l_display_name VARCHAR2(240);
3759:
3760: -- Fix for Bug 7167583

Line 4329: l_requestor_display_name per_people_f.full_name%type;

4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;