DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on PER_PEOPLE_F

Line 381: l_display_name per_people_f.full_name%type;

377:
378: l_role_name VARCHAR2(30):= 'AR_CMGT_CREDIT_ANALYST_ROLE';
379: l_role_display_name VARCHAR2(240) := 'Credit Analyst Role';
380: l_user_name fnd_user.user_name%type;
381: l_display_name per_people_f.full_name%type;
382:
383: CURSOR c_get_resource_id IS
384: SELECT c.resource_id, c.source_id --employee id
385: FROM jtf_rs_role_relations a,

Line 716: l_employee_id per_people_f.person_id%type;

712: l_user_name VARCHAR2(60);
713: l_display_name VARCHAR2(240);
714: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
715: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;
716: l_employee_id per_people_f.person_id%type;
717: l_dummy VARCHAR2(1);
718: BEGIN
719: IF funcmode = 'RUN'
720: THEN

Line 1166: l_requestor_display_name per_people_f.full_name%type;

1162: l_application_number ar_cmgt_credit_requests.application_number%type;
1163: l_score_model_already_set VARCHAR2(1) := 'F';
1164: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1165: l_requestor_user_name fnd_user.user_name%type;
1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;

Line 3280: l_person_id per_people_f.person_id%type;

3276: p_attribute_type IN VARCHAR2,
3277: p_attribute_name IN VARCHAR2,
3278: p_attribute_value IN VARCHAR2 ) IS
3279:
3280: l_person_id per_people_f.person_id%type;
3281: l_user_name VARCHAR2(60);
3282: l_display_name VARCHAR2(240);
3283:
3284: BEGIN

Line 3821: l_requestor_display_name per_people_f.full_name%type;

3817: l_application_number ar_cmgt_credit_requests.application_number%type;
3818: l_score_model_already_set VARCHAR2(1) := 'F';
3819: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
3820: l_requestor_user_name fnd_user.user_name%type;
3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;