APPS.BEN_TCS_COMPENSATION dependencies on PER_TIME_PERIODS_V

Line 772: Select * from PER_TIME_PERIODS_V

768: AND asg.ASSIGNMENT_STATUS_TYPE_ID = status.ASSIGNMENT_STATUS_TYPE_ID
769: AND status.per_system_status IN ('ACTIVE_ASSIGN' , 'ACTIVE_CWK');
770:
771: cursor csr_payroll_periods (p_pay_id number, p_psd date, p_ped date )is
772: Select * from PER_TIME_PERIODS_V
773: where payroll_id = p_pay_id
774: and not(start_date > p_ped)
775: and not(end_date < p_psd );
776: