eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 209: per_all_assignments_f paf

205: paf.location_id loc_id,
206: paf.soft_coding_keyflex_id flex_id,
207: paf.effective_start_date st_dt
208: from
209: per_all_assignments_f paf
210: where paf.person_id = p_person_id and
211: paf.effective_end_date >= p_start_date and
212: paf.business_group_id = p_business_group_id and
213: paf.primary_flag = 'Y' and

Line 217: from per_all_assignments_f paf1

213: paf.primary_flag = 'Y' and
214: -- commented for bug 10287946
215: --job_exists(paf.job_id) is not null and
216: paf.effective_start_date = (select max(effective_start_date)
217: from per_all_assignments_f paf1
218: where paf1.business_group_id = p_business_group_id
219: and paf1.assignment_id = paf.assignment_id
220: and paf1.person_id = p_person_id);
221:

Line 234: per_all_assignments_f paf,

230: decode (substr(NVL(paf.employment_category,'-1'),1,2),'FR','01','PR','02','PT','05','FT','03','-1','-1','04') employment_category,
231: paf.location_id loc_id,
232: paf.effective_start_date st_dt
233: from
234: per_all_assignments_f paf,
235: hr_soft_coding_keyflex hsck,
236: hr_lookups hl
237: where paf.person_id = p_person_id and
238: paf.business_group_id = p_business_group_id and

Line 245: from per_all_assignments_f paf1

241: -- commented for bug 10287946
242: --job_exists(paf.job_id) is not null and
243: hl.lookup_type = 'NAIC' and
244: paf.effective_start_date = (select max(effective_start_date)
245: from per_all_assignments_f paf1
246: where paf1.business_group_id = p_business_group_id
247: and paf1.assignment_id = paf.assignment_id
248: and paf1.person_id = p_person_id) and
249: hsck.soft_coding_keyflex_id=paf.soft_coding_keyflex_id and

Line 303: per_all_assignments_f paf,

299: trunc(ppos.actual_termination_date) term_date,
300: trunc(ppos.projected_termination_date) end_dt
301: from
302: per_all_people_f ppf,
303: per_all_assignments_f paf,
304: per_periods_of_service ppos
305: where person_type_exists(ppf.person_type_id) is not null and
306: paf.person_id = ppf.person_id and
307: ppos.actual_termination_date between

Line 333: per_all_assignments_f paf,

329: trunc(ppos.actual_termination_date) term_date,
330: trunc(ppos.projected_termination_date) end_dt
331: from
332: per_all_people_f ppf,
333: per_all_assignments_f paf,
334: per_periods_of_service ppos
335: where person_type_exists(ppf.person_type_id) is not null and
336: paf.person_id = ppf.person_id and
337: ppf.business_group_id=p_business_group_id and

Line 361: per_all_assignments_f paf,

357: cursor c_total_salary (p_person_id number) is
358: --select sum(trunc(to_number(pppv.proposed_salary)) * ppb.pay_annualization_factor) salary
359: select round(sum(to_number(pppv.proposed_salary) * ppb.pay_annualization_factor)) salary
360: from per_pay_bases ppb,
361: per_all_assignments_f paf,
362: per_all_people_f ppf,
363: per_pay_proposals_v2 pppv,
364: per_assignment_status_types past,
365: hr_lookups hrl

Line 379: from per_all_assignments_f paf1,

375: paf.person_id = p_person_id and
376: paf.assignment_id=pppv.assignment_id and
377: pppv.approved = 'Y' and -- to calculate only approved salaries
378: paf.effective_start_date = ( select max(effective_start_date)
379: from per_all_assignments_f paf1,
380: per_assignment_status_types past1,
381: hr_lookups hrl1
382: where paf1.business_group_id = p_business_group_id
383: and paf1.assignment_id = pppv.assignment_id

Line 459: per_all_assignments_f paf

455: select distinct ppp.assignment_id asg_id,
456: TRUNC(ppp.change_date) promo_date
457: from per_pay_proposals_v2 ppp,
458: per_all_people_f ppf,
459: per_all_assignments_f paf
460: where ppf.person_id = paf.person_id and
461: ppf.person_id = p_person_id and
462: paf.assignment_id = ppp.assignment_id and
463: ppf.effective_end_date > p_start_date and

Line 487: l_loc_id per_all_assignments_f.location_id%type;

483: l_first_name per_all_people_f.first_name%type;
484: l_last_name per_all_people_f.last_name%type;
485: l_employment_category varchar2(5);
486: l_gender per_all_people_f.sex%type;
487: l_loc_id per_all_assignments_f.location_id%type;
488: l_asg_id per_all_assignments_f.assignment_id%type;
489: l_province varchar2(5);
490: l_desg_abor per_all_people_f.per_information5%type;
491: l_desg_vminor per_all_people_f.per_information6%type;

Line 488: l_asg_id per_all_assignments_f.assignment_id%type;

484: l_last_name per_all_people_f.last_name%type;
485: l_employment_category varchar2(5);
486: l_gender per_all_people_f.sex%type;
487: l_loc_id per_all_assignments_f.location_id%type;
488: l_asg_id per_all_assignments_f.assignment_id%type;
489: l_province varchar2(5);
490: l_desg_abor per_all_people_f.per_information5%type;
491: l_desg_vminor per_all_people_f.per_information6%type;
492: l_desg_disab per_all_people_f.per_information7%type;