APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 41: per_all_people_f and per_all_assignments_f

37: inserting temporary employees as well as
38: Promoted employee details.
39: 05-Jul-2005 ssmukher 115.2 Modified the cursor c_promo.
40: Modified the effective end date condition for
41: per_all_people_f and per_all_assignments_f
42: table
43: 05-Jul-2005 ssmukher 115.3 Modified the code so that if the designated
44: code is not specified for an employee then
45: record is not inserted into the exception

Line 188: per_all_assignments_f paf

184: paf.location_id loc_id,
185: paf.soft_coding_keyflex_id flex_id,
186: paf.effective_start_date st_dt
187: from
188: per_all_assignments_f paf
189: where paf.person_id = p_person_id and
190: paf.effective_end_date >= p_start_date and
191: paf.business_group_id = p_business_group_id and
192: paf.primary_flag = 'Y' and

Line 195: from per_all_assignments_f paf1

191: paf.business_group_id = p_business_group_id and
192: paf.primary_flag = 'Y' and
193: job_exists(paf.job_id) is not null and
194: paf.effective_start_date = (select max(effective_start_date)
195: from per_all_assignments_f paf1
196: where paf1.business_group_id = p_business_group_id
197: and paf1.assignment_id = paf.assignment_id
198: and paf1.person_id = p_person_id);
199:

Line 212: per_all_assignments_f paf,

208: decode (substr(NVL(paf.employment_category,'-1'),1,2),'FR','01','PR','02','PT','03','FT','03','-1','-1','04') employment_category,
209: paf.location_id loc_id,
210: paf.effective_start_date st_dt
211: from
212: per_all_assignments_f paf,
213: hr_soft_coding_keyflex hsck,
214: hr_lookups hl
215: where paf.person_id = p_person_id and
216: paf.business_group_id = p_business_group_id and

Line 222: from per_all_assignments_f paf1

218: paf.primary_flag = 'Y' and
219: job_exists(paf.job_id) is not null and
220: hl.lookup_type = 'NAIC' and
221: paf.effective_start_date = (select max(effective_start_date)
222: from per_all_assignments_f paf1
223: where paf1.business_group_id = p_business_group_id
224: and paf1.assignment_id = paf.assignment_id
225: and paf1.person_id = p_person_id) and
226: hsck.soft_coding_keyflex_id=paf.soft_coding_keyflex_id and

Line 280: per_all_assignments_f paf,

276: trunc(ppos.actual_termination_date) term_date,
277: trunc(ppos.projected_termination_date) end_dt
278: from
279: per_all_people_f ppf,
280: per_all_assignments_f paf,
281: per_periods_of_service ppos
282: where person_type_exists(ppf.person_type_id) is not null and
283: paf.person_id = ppf.person_id and
284: ppos.actual_termination_date between

Line 307: per_all_assignments_f paf,

303: for the assignment */
304: cursor c_total_salary (p_person_id number) is
305: select sum(trunc(to_number(pppv.proposed_salary)) * ppb.pay_annualization_factor) salary
306: from per_pay_bases ppb,
307: per_all_assignments_f paf,
308: per_all_people_f ppf,
309: per_pay_proposals_v2 pppv,
310: per_assignment_status_types past,
311: hr_lookups hrl

Line 324: from per_all_assignments_f paf1,

320: ppb.business_group_id = p_business_group_id and
321: paf.person_id = p_person_id and
322: paf.assignment_id=pppv.assignment_id and
323: paf.effective_start_date = ( select max(effective_start_date)
324: from per_all_assignments_f paf1,
325: per_assignment_status_types past1,
326: hr_lookups hrl1
327: where paf1.business_group_id = p_business_group_id
328: and paf1.assignment_id = pppv.assignment_id

Line 402: per_all_assignments_f paf

398: select distinct ppp.assignment_id asg_id,
399: TRUNC(ppp.change_date) promo_date
400: from per_pay_proposals_v2 ppp,
401: per_all_people_f ppf,
402: per_all_assignments_f paf
403: where ppf.person_id = paf.person_id and
404: ppf.person_id = p_person_id and
405: paf.assignment_id = ppp.assignment_id and
406: ppf.effective_end_date > p_start_date and

Line 430: l_loc_id per_all_assignments_f.location_id%type;

426: l_first_name per_all_people_f.first_name%type;
427: l_last_name per_all_people_f.last_name%type;
428: l_employment_category varchar2(5);
429: l_gender per_all_people_f.sex%type;
430: l_loc_id per_all_assignments_f.location_id%type;
431: l_asg_id per_all_assignments_f.assignment_id%type;
432: l_province varchar2(5);
433: l_desg_abor per_all_people_f.per_information5%type;
434: l_desg_vminor per_all_people_f.per_information6%type;

Line 431: l_asg_id per_all_assignments_f.assignment_id%type;

427: l_last_name per_all_people_f.last_name%type;
428: l_employment_category varchar2(5);
429: l_gender per_all_people_f.sex%type;
430: l_loc_id per_all_assignments_f.location_id%type;
431: l_asg_id per_all_assignments_f.assignment_id%type;
432: l_province varchar2(5);
433: l_desg_abor per_all_people_f.per_information5%type;
434: l_desg_vminor per_all_people_f.per_information6%type;
435: l_desg_disab per_all_people_f.per_information7%type;