APPS.MSD_DEM_EVENT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 43: p_user_org_name hr_all_organization_units.name%type;

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;
47: p_user_product number;

Line 234: from hr_all_organization_units

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

Line 589: p_user_org_name hr_all_organization_units.name%type;

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;
593: p_user_product number;

Line 737: from hr_all_organization_units

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