APPS.MSD_DEM_EVENT dependencies on PER_ALL_PEOPLE_F

Line 41: p_user_fname per_all_people_f.first_name%type;

37: p_user_name fnd_user.user_name%type;
38: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
39: p_user_valid number;
40: p_user_resp number;
41: p_user_fname per_all_people_f.first_name%type;
42: p_user_lname per_all_people_f.last_name%type;
43: p_user_org_name hr_all_organization_units.name%type;
44: p_user_wrkphone per_all_people_f.work_telephone%type;
45: p_user_fax fnd_user.fax%type;

Line 42: p_user_lname per_all_people_f.last_name%type;

38: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
39: p_user_valid number;
40: p_user_resp number;
41: p_user_fname per_all_people_f.first_name%type;
42: p_user_lname per_all_people_f.last_name%type;
43: p_user_org_name hr_all_organization_units.name%type;
44: p_user_wrkphone per_all_people_f.work_telephone%type;
45: p_user_fax fnd_user.fax%type;
46: p_user_email fnd_user.email_address%type;

Line 44: p_user_wrkphone per_all_people_f.work_telephone%type;

40: p_user_resp number;
41: p_user_fname per_all_people_f.first_name%type;
42: p_user_lname per_all_people_f.last_name%type;
43: p_user_org_name hr_all_organization_units.name%type;
44: p_user_wrkphone per_all_people_f.work_telephone%type;
45: p_user_fax fnd_user.fax%type;
46: p_user_email fnd_user.email_address%type;
47: p_user_product number;
48: Duser_cnt number;

Line 210: from per_all_people_f

206: AND fme.sub_menu_id IS NULL
207: AND fff.function_id = fme.function_id
208: AND fff.function_name = ''MSD_DEM_WF_MGR''))) user_type,
209: ( select first_name
210: from per_all_people_f
211: where ((person_id = fu.employee_id
212: and fu.employee_id is not null)
213: or
214: (party_id = fu.person_party_id

Line 222: from per_all_people_f

218: or (party_id = fu.customer_id
219: and fu.customer_id is not null))
220: and rownum <2) first_name,
221: ( select last_name
222: from per_all_people_f
223: where ((person_id = fu.employee_id
224: and fu.employee_id is not null)
225: or
226: (party_id = fu.person_party_id

Line 237: from per_all_people_f pap

233: ( select name
234: from hr_all_organization_units
235: where business_group_id in
236: (select pap.business_group_id
237: from per_all_people_f pap
238: where (pap.person_id = fu.employee_id
239: and fu.employee_id is not null)
240: or
241: (pap.party_id = fu.person_party_id

Line 249: from per_all_people_f

245: or (pap.party_id = fu.customer_id
246: and fu.customer_id is not null))
247: and rownum < 2) company,
248: ( select work_telephone
249: from per_all_people_f
250: where ((person_id = fu.employee_id
251: and fu.employee_id is not null)
252: or
253: (party_id = fu.person_party_id

Line 264: from per_all_people_f pap

260: fu.fax,
261: decode(fu.email_address,
262: null,
263: (select pap.email_address
264: from per_all_people_f pap
265: where ((person_id = fu.employee_id
266: and fu.employee_id is not null)
267: or
268: (party_id = fu.person_party_id

Line 587: p_user_fname per_all_people_f.first_name%type;

583: p_user_name fnd_user.user_name%type;
584: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
585: p_user_valid number;
586: p_user_resp number;
587: p_user_fname per_all_people_f.first_name%type;
588: p_user_lname per_all_people_f.last_name%type;
589: p_user_org_name hr_all_organization_units.name%type;
590: p_user_wrkphone per_all_people_f.work_telephone%type;
591: p_user_fax fnd_user.fax%type;

Line 588: p_user_lname per_all_people_f.last_name%type;

584: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
585: p_user_valid number;
586: p_user_resp number;
587: p_user_fname per_all_people_f.first_name%type;
588: p_user_lname per_all_people_f.last_name%type;
589: p_user_org_name hr_all_organization_units.name%type;
590: p_user_wrkphone per_all_people_f.work_telephone%type;
591: p_user_fax fnd_user.fax%type;
592: p_user_email fnd_user.email_address%type;

Line 590: p_user_wrkphone per_all_people_f.work_telephone%type;

586: p_user_resp number;
587: p_user_fname per_all_people_f.first_name%type;
588: p_user_lname per_all_people_f.last_name%type;
589: p_user_org_name hr_all_organization_units.name%type;
590: p_user_wrkphone per_all_people_f.work_telephone%type;
591: p_user_fax fnd_user.fax%type;
592: p_user_email fnd_user.email_address%type;
593: p_user_product number;
594: Duser_cnt number;

Line 713: from per_all_people_f

709: AND fme.sub_menu_id IS NULL
710: AND fff.function_id = fme.function_id
711: AND fff.function_name = ''MSD_DEM_SOP_WF_MGR''))) user_type,
712: ( select first_name
713: from per_all_people_f
714: where ((person_id = fu.employee_id
715: and fu.employee_id is not null)
716: or
717: (party_id = fu.person_party_id

Line 725: from per_all_people_f

721: or (party_id = fu.customer_id
722: and fu.customer_id is not null))
723: and rownum <2) first_name,
724: ( select last_name
725: from per_all_people_f
726: where ((person_id = fu.employee_id
727: and fu.employee_id is not null)
728: or
729: (party_id = fu.person_party_id

Line 740: from per_all_people_f pap

736: ( select name
737: from hr_all_organization_units
738: where business_group_id in
739: (select pap.business_group_id
740: from per_all_people_f pap
741: where (pap.person_id = fu.employee_id
742: and fu.employee_id is not null)
743: or
744: (pap.party_id = fu.person_party_id

Line 752: from per_all_people_f

748: or (pap.party_id = fu.customer_id
749: and fu.customer_id is not null))
750: and rownum < 2) company,
751: ( select work_telephone
752: from per_all_people_f
753: where ((person_id = fu.employee_id
754: and fu.employee_id is not null)
755: or
756: (party_id = fu.person_party_id

Line 767: from per_all_people_f pap

763: fu.fax,
764: decode(fu.email_address,
765: null,
766: (select pap.email_address
767: from per_all_people_f pap
768: where ((person_id = fu.employee_id
769: and fu.employee_id is not null)
770: or
771: (party_id = fu.person_party_id