APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_ALL_PEOPLE_F

Line 158: from per_all_people_f

154:
155: cursor csr_closest_name1
156: (b_person_id in number,b_effective_date date) is
157: select full_name
158: from per_all_people_f
159: where person_id = b_person_id
160: and (effective_end_date=(select max(effective_end_date) from per_all_people_f
161: where person_id=b_person_id and(effective_end_date<= b_effective_date)));
162:

Line 160: and (effective_end_date=(select max(effective_end_date) from per_all_people_f

156: (b_person_id in number,b_effective_date date) is
157: select full_name
158: from per_all_people_f
159: where person_id = b_person_id
160: and (effective_end_date=(select max(effective_end_date) from per_all_people_f
161: where person_id=b_person_id and(effective_end_date<= b_effective_date)));
162:
163:
164: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is

Line 166: from per_all_people_f

162:
163:
164: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is
165: select full_name
166: from per_all_people_f
167: where person_id = b_person_id
168: and (effective_start_date=(select min(effective_start_date) from per_all_people_f
169: where person_id=b_person_id and
170: (effective_start_date>= b_effective_date)));

Line 168: and (effective_start_date=(select min(effective_start_date) from per_all_people_f

164: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is
165: select full_name
166: from per_all_people_f
167: where person_id = b_person_id
168: and (effective_start_date=(select min(effective_start_date) from per_all_people_f
169: where person_id=b_person_id and
170: (effective_start_date>= b_effective_date)));
171:
172:

Line 173: l_temp_name per_all_people_f.full_name%type;

169: where person_id=b_person_id and
170: (effective_start_date>= b_effective_date)));
171:
172:
173: l_temp_name per_all_people_f.full_name%type;
174: l_name wf_users.name%type;
175: l_display_name wf_users.display_name%type;
176:
177: begin

Line 1144: query involving per_all_people_f and fnd_user

1140:
1141: -- Bug 8783079
1142: /* The real approver's self service login can be got in 2 ways
1143: 1. Directly query on FND_USER using the employee_id of the real approver (l_real_approver) through a
1144: query involving per_all_people_f and fnd_user
1145: 2. From wf attribute APR_SS_LOGIN which already has the approver's self-service logn
1146:
1147: We go by method 2
1148: */

Line 2131: --Changed for 115.60; used per_all_people_f instead of per_people_f

2127: raise;
2128: end person_approval;
2129:
2130: --Function to check if a given approver is terminated (Bug#3160848)
2131: --Changed for 115.60; used per_all_people_f instead of per_people_f
2132: FUNCTION validate_person(
2133: p_person_id in number,
2134: p_effective_date in date)
2135: RETURN BOOLEAN

Line 2140: FROM per_all_people_f per,

2136: is
2137:
2138: cursor csr_validate_person(b_person_id number, b_effective_date date) is
2139: SELECT 1
2140: FROM per_all_people_f per,
2141: per_person_types ppt,
2142: per_person_type_usages_f pptu
2143: WHERE per.person_id = b_person_id
2144: AND TRUNC(b_effective_date) between TRUNC(per.effective_Start_date) and TRUNC(per.effective_end_date)