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 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

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

759: and asg.effective_start_date <= p_perd_en_dt
760: and asg.effective_end_date >= p_perd_st_dt
761: and asg.payroll_id is not null
762: and pay.payroll_id = asg.payroll_id
763: and pay.effective_end_date = (select max(effective_end_date) from pay_payrolls_f where payroll_id =
764: asg.payroll_id )
765: and period.period_type = pay.period_type
766: AND nvl(status.business_group_id,asg.business_group_id) = asg.business_group_id
767: AND status.active_flag = 'Y'