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_NEW_HIRE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 5104: per_all_assignments_f paf, --table

5100: From
5101: --per_people_f ppf, --view bug 4912696
5102: per_all_people_f ppf, --table
5103: --per_assignments_f paf, --view bug 4912696
5104: per_all_assignments_f paf, --table
5105: per_jobs job
5106: Where
5107: ppf.person_id = p_person_id
5108: And ppf.business_group_id + 0 = p_business_group_id

Line 5282: l_payroll_id per_all_assignments_f.payroll_id%type;

5278: l_salary number;
5279: l_normal_hours number;
5280: l_work_schedule varchar2(150);
5281: l_annual_salary number;
5282: l_payroll_id per_all_assignments_f.payroll_id%type;
5283: l_number_per_fiscal_year number;
5284: --
5285: Begin
5286: --

Line 5358: per_all_assignments_f paf

5354: 'PERIOD','P'
5355: )
5356: into p_frequency
5357: from per_pay_bases ppb ,
5358: per_all_assignments_f paf
5359: where paf.assignment_id = p_assignment_id
5360: and ppb.pay_basis_id = paf.pay_basis_id
5361: and ppb.BUSINESS_GROUP_ID=p_business_group_id ;
5362:

Line 5387: per_all_assignments_f paf

5383: INTO l_number_per_fiscal_year ,
5384: p_frequency
5385: FROM pay_payrolls_f prl,
5386: per_time_period_types ptp,
5387: per_all_assignments_f paf
5388: WHERE ptp.period_type = prl.period_type
5389: and paf.assignment_id = p_assignment_id
5390: and prl.payroll_id = paf.payroll_id
5391: and prl.business_group_id + 0 = p_business_group_id