APPS.MSD_DEM_EVENT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 47: p_user_org_name hr_all_organization_units.name%type;

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;
51: -- p_user_language number; --commenting out MLS nallkuma

Line 279: from hr_all_organization_units

275: or (party_id = fu.customer_id
276: and fu.customer_id is not null))
277: and rownum <2) last_name,
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

Line 633: p_user_org_name hr_all_organization_units.name%type;

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;
637: -- p_user_language number; --commenting out MLS nallkuma

Line 786: from hr_all_organization_units

782: or (party_id = fu.customer_id
783: and fu.customer_id is not null))
784: and rownum <2) last_name,
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