eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_TCS_COMPENSATION dependencies on PAY_PAYROLLS_F

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

Line 830: and pay.effective_end_date = (select max(effective_end_date) from pay_payrolls_f where payroll_id =

826: and asg.effective_start_date <= p_perd_en_dt
827: and asg.effective_end_date >= p_perd_st_dt
828: and asg.payroll_id is not null
829: and pay.payroll_id = asg.payroll_id
830: and pay.effective_end_date = (select max(effective_end_date) from pay_payrolls_f where payroll_id =
831: asg.payroll_id )
832: and period.period_type = pay.period_type
833: AND nvl(status.business_group_id,asg.business_group_id) = asg.business_group_id
834: AND status.active_flag = 'Y'