APPS.HR_PAY_RATE_SS dependencies on PER_ASSIGNMENTS_F

Line 453: From per_pay_proposals pp, per_assignments_f paf,

449: ln_last_pay2 NUMBER ;
450:
451: CURSOR c_last_pay IS
452: Select pp.proposed_salary_n*pay_annualization_factor
453: From per_pay_proposals pp, per_assignments_f paf,
454: per_pay_bases ppb
455: Where pp.assignment_id = p_assignment_id
456: And pp.business_group_id = p_bus_group_id
457: And pp.approved = 'Y'

Line 505: FROM per_jobs jobs , per_assignments_f asg

501: l_proc varchar2(200) := g_package || 'get_flsa_status';
502:
503: CURSOR lc_flsa_status IS
504: SELECT job_information3
505: FROM per_jobs jobs , per_assignments_f asg
506: WHERE jobs.job_id = asg.job_id
507: -- AND jobs.business_group_id = asg.business_group_id
508: -- Fix 2094081
509: AND p_date between asg.effective_start_date and asg.effective_end_date