APPS.MSD_DEM_EVENT dependencies on PER_ALL_PEOPLE_F

Line 45: p_user_fname per_all_people_f.first_name%type;

41: p_user_name fnd_user.user_name%type;
42: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
43: p_user_valid number;
44: p_user_resp number;
45: p_user_fname per_all_people_f.first_name%type;
46: p_user_lname per_all_people_f.last_name%type;
47: p_user_org_name hr_all_organization_units.name%type;
48: p_user_wrkphone per_all_people_f.work_telephone%type;
49: p_user_fax fnd_user.fax%type;

Line 46: p_user_lname per_all_people_f.last_name%type;

42: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
43: p_user_valid number;
44: p_user_resp number;
45: p_user_fname per_all_people_f.first_name%type;
46: p_user_lname per_all_people_f.last_name%type;
47: p_user_org_name hr_all_organization_units.name%type;
48: p_user_wrkphone per_all_people_f.work_telephone%type;
49: p_user_fax fnd_user.fax%type;
50: p_user_email fnd_user.email_address%type;

Line 48: p_user_wrkphone per_all_people_f.work_telephone%type;

44: p_user_resp number;
45: p_user_fname per_all_people_f.first_name%type;
46: p_user_lname per_all_people_f.last_name%type;
47: p_user_org_name hr_all_organization_units.name%type;
48: p_user_wrkphone per_all_people_f.work_telephone%type;
49: p_user_fax fnd_user.fax%type;
50: p_user_email fnd_user.email_address%type;
51: -- p_user_language number; --commenting out MLS nallkuma
52: p_user_product number;

Line 255: from per_all_people_f

251: AND fme.sub_menu_id = sub_fme.menu_id
252: AND fff.function_id = sub_fme.function_id
253: AND fff.function_name = ''MSD_SPF_WF_MGR''))) user_type,
254: ( select first_name
255: from per_all_people_f
256: where ((person_id = fu.employee_id
257: and fu.employee_id is not null)
258: or
259: (party_id = fu.person_party_id

Line 267: from per_all_people_f

263: or (party_id = fu.customer_id
264: and fu.customer_id is not null))
265: and rownum <2) first_name,
266: ( select last_name
267: from per_all_people_f
268: where ((person_id = fu.employee_id
269: and fu.employee_id is not null)
270: or
271: (party_id = fu.person_party_id

Line 282: from per_all_people_f pap

278: ( select name
279: from hr_all_organization_units
280: where business_group_id in
281: (select pap.business_group_id
282: from per_all_people_f pap
283: where (pap.person_id = fu.employee_id
284: and fu.employee_id is not null)
285: or
286: (pap.party_id = fu.person_party_id

Line 294: from per_all_people_f

290: or (pap.party_id = fu.customer_id
291: and fu.customer_id is not null))
292: and rownum < 2) company,
293: ( select work_telephone
294: from per_all_people_f
295: where ((person_id = fu.employee_id
296: and fu.employee_id is not null)
297: or
298: (party_id = fu.person_party_id

Line 309: from per_all_people_f pap

305: fu.fax,
306: decode(fu.email_address,
307: null,
308: (select pap.email_address
309: from per_all_people_f pap
310: where ((person_id = fu.employee_id
311: and fu.employee_id is not null)
312: or
313: (party_id = fu.person_party_id

Line 631: p_user_fname per_all_people_f.first_name%type;

627: p_user_name fnd_user.user_name%type;
628: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
629: p_user_valid number;
630: p_user_resp number;
631: p_user_fname per_all_people_f.first_name%type;
632: p_user_lname per_all_people_f.last_name%type;
633: p_user_org_name hr_all_organization_units.name%type;
634: p_user_wrkphone per_all_people_f.work_telephone%type;
635: p_user_fax fnd_user.fax%type;

Line 632: p_user_lname per_all_people_f.last_name%type;

628: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
629: p_user_valid number;
630: p_user_resp number;
631: p_user_fname per_all_people_f.first_name%type;
632: p_user_lname per_all_people_f.last_name%type;
633: p_user_org_name hr_all_organization_units.name%type;
634: p_user_wrkphone per_all_people_f.work_telephone%type;
635: p_user_fax fnd_user.fax%type;
636: p_user_email fnd_user.email_address%type;

Line 634: p_user_wrkphone per_all_people_f.work_telephone%type;

630: p_user_resp number;
631: p_user_fname per_all_people_f.first_name%type;
632: p_user_lname per_all_people_f.last_name%type;
633: p_user_org_name hr_all_organization_units.name%type;
634: p_user_wrkphone per_all_people_f.work_telephone%type;
635: p_user_fax fnd_user.fax%type;
636: p_user_email fnd_user.email_address%type;
637: -- p_user_language number; --commenting out MLS nallkuma
638: p_user_product number;

Line 762: from per_all_people_f

758: AND fme.sub_menu_id IS NULL
759: AND fff.function_id = fme.function_id
760: AND fff.function_name = ''MSD_DEM_SOP_WF_MGR''))) user_type,
761: ( select first_name
762: from per_all_people_f
763: where ((person_id = fu.employee_id
764: and fu.employee_id is not null)
765: or
766: (party_id = fu.person_party_id

Line 774: from per_all_people_f

770: or (party_id = fu.customer_id
771: and fu.customer_id is not null))
772: and rownum <2) first_name,
773: ( select last_name
774: from per_all_people_f
775: where ((person_id = fu.employee_id
776: and fu.employee_id is not null)
777: or
778: (party_id = fu.person_party_id

Line 789: from per_all_people_f pap

785: ( select name
786: from hr_all_organization_units
787: where business_group_id in
788: (select pap.business_group_id
789: from per_all_people_f pap
790: where (pap.person_id = fu.employee_id
791: and fu.employee_id is not null)
792: or
793: (pap.party_id = fu.person_party_id

Line 801: from per_all_people_f

797: or (pap.party_id = fu.customer_id
798: and fu.customer_id is not null))
799: and rownum < 2) company,
800: ( select work_telephone
801: from per_all_people_f
802: where ((person_id = fu.employee_id
803: and fu.employee_id is not null)
804: or
805: (party_id = fu.person_party_id

Line 816: from per_all_people_f pap

812: fu.fax,
813: decode(fu.email_address,
814: null,
815: (select pap.email_address
816: from per_all_people_f pap
817: where ((person_id = fu.employee_id
818: and fu.employee_id is not null)
819: or
820: (party_id = fu.person_party_id