APPS.PAY_FF_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 477: from per_assignments_f

473: l_both_plans number;
474: l_effective_date date;
475: cursor c_person is
476: select person_id
477: from per_assignments_f
478: where assignment_id = p_assignment_id;
479:
480: cursor c1 is
481: select c.person_id

Line 540: per_assignments_f ass,

536: pro.proposed_salary_n *
537: nvl(ppb.pay_annualization_factor,tpt.number_per_fiscal_year) last_anul_sal
538: FROM per_people_f per,
539: per_time_period_types tpt,
540: per_assignments_f ass,
541: per_pay_bases ppb,
542: per_pay_proposals pro,
543: pay_all_payrolls_f prl
544: WHERE per.person_id = ass.person_id

Line 677: per_assignments_f paf

673: select
674: sum(max(contr.max_contr_allowed) - sum(contr.amt_contr)) amt
675: from
676: pay_us_contribution_history contr,
677: per_assignments_f paf
678: where
679: paf.assignment_id = p_assignment_id
680: and l_effective_date between paf.effective_start_date and
681: nvl(paf.effective_end_date, l_effective_date)