DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on PER_TIME_PERIODS

Line 930: From per_time_periods tpe

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

Line 960: from per_time_periods tpe

956: --
957: cursor c_next_pay_period is
958: select tpe.start_date
959: ,tpe.end_date
960: from per_time_periods tpe
961: ,per_all_assignments_f asg
962: where tpe.payroll_id = asg.payroll_id
963: and asg.person_id = p_person_id
964: and asg.assignment_type <> 'C'