DBA Data[Home] [Help]

APPS.BEN_TCS_COMPENSATION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 823: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status

819: asg.effective_end_date,
820: number_per_fiscal_year,
821: status.pay_system_status
822: from per_all_assignments_f asg,
823: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status
824: where assignment_id = p_assignment_id
825: --vkodedal = is added to fix payroll period issue 07-Sep-07
826: and asg.effective_start_date <= p_perd_en_dt
827: and asg.effective_end_date >= p_perd_st_dt