DBA Data[Home] [Help]

APPS.BEN_TCS_COMPENSATION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 756: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status

752: select distinct asg.payroll_id,
753: asg.effective_start_date,
754: asg.effective_end_date,number_per_fiscal_year
755: from per_all_assignments_f asg,
756: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status
757: where assignment_id = p_assignment_id
758: --vkodedal = is added to fix payroll period issue 07-Sep-07
759: and asg.effective_start_date <= p_perd_en_dt
760: and asg.effective_end_date >= p_perd_st_dt