DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PER_PERIODS_OF_SERVICE

Line 469: per_periods_of_service pds

465: cursor c_get_asg_id_term (p_person_id number) is
466: select paf.assignment_id,
467: paf.effective_end_date
468: from per_assignments_f paf,
469: per_periods_of_service pds
470: where paf.person_id = p_person_id
471: and paf.primary_flag = 'Y'
472: and paf.assignment_type = 'E'
473: and paf.effective_start_date <= l_year_end