DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on PER_TIME_PERIODS

Line 926: From per_time_periods tpe

922: --
923: cursor c_time_periods is
924: select tpe.start_date
925: ,tpe.end_date
926: From per_time_periods tpe
927: ,per_all_assignments_f paf
928: Where paf.person_id = p_person_id
929: and paf.primary_flag = 'Y'
930: and paf.assignment_type <> 'C'

Line 956: from per_time_periods tpe

952: --
953: cursor c_next_pay_period is
954: select tpe.start_date
955: ,tpe.end_date
956: from per_time_periods tpe
957: ,per_all_assignments_f asg
958: where tpe.payroll_id = asg.payroll_id
959: and asg.person_id = p_person_id
960: and asg.assignment_type <> 'C'