DBA Data[Home] [Help]

APPS.BEN_WHATIF_ELIG dependencies on PER_ASSIGNMENTS_F

Line 4331: per_assignments_f paf

4327: paf.BUSINESS_GROUP_ID,
4328: paf.effective_start_date,
4329: paf.effective_end_date
4330: from per_all_people_f per,
4331: per_assignments_f paf
4332: where per.person_id = p_person_id
4333: and paf.assignment_type <> 'C'
4334: and p_effective_date
4335: between per.effective_start_date

Line 4350: per_assignments_f paf,

4346: --
4347: cursor c_exist_fte is
4348: select pab.ASSIGNMENT_BUDGET_VALUE_ID
4349: from per_all_people_f per,
4350: per_assignments_f paf,
4351: per_assignment_budget_values pab
4352: where per.person_id = p_person_id
4353: and paf.assignment_type <> 'C'
4354: and p_effective_date