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.PER_ASG_AGGR dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 75: per_assignment_status_types past

71: SELECT COUNT(hsck.segment1) Num, hsck.segment1 tax_district
72: FROM hr_soft_coding_keyflex hsck,
73: pay_all_payrolls_f papf,
74: per_all_assignments_f paaf,
75: per_assignment_status_types past
76: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
77: AND papf.payroll_id =paaf.payroll_id
78: AND past.assignment_status_type_id = paaf.assignment_status_type_id
79: AND paaf.person_id = p_person_id

Line 152: per_assignment_status_types past

148: and exists ( SELECT 1
149: FROM per_all_assignments_f paaf,
150: pay_all_payrolls_f papf,
151: hr_soft_coding_keyflex hsck,
152: per_assignment_status_types past
153: WHERE paaf.person_id = p_person_id
154: and paaf.assignment_id not in (paa.assignment_id)
155: and paaf.effective_start_date <= p_end_date
156: and paaf.effective_end_date >= p_start_date

Line 525: l_cur_agg_paye_flag per_assignment_status_types.per_system_status%type;

521: IS
522:
523: -- Start of bug#8370225
524: l_effective_date date;
525: l_cur_agg_paye_flag per_assignment_status_types.per_system_status%type;
526: l_cur_paye_agg_flag per_all_people_f.per_information10%type;
527: l_curr_ni_agg_flag per_all_people_f.per_information9%type;
528: l_cur_effective_start_date date;
529: l_cur_effective_end_date date;

Line 564: per_assignment_status_types past

560: select 1
561: from pay_all_payrolls_f papf,
562: per_all_assignments_f paaf,
563: hr_soft_coding_keyflex hsck,
564: per_assignment_status_types past
565: where paaf.person_id = c_person_id
566: and paaf.effective_start_date <= c_end_date-1
567: and paaf.effective_end_date >= c_start_date
568: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 577: per_assignment_status_types ast

573: and exists ( select 1
574: from pay_all_payrolls_f apf,
575: per_all_assignments_f aaf,
576: hr_soft_coding_keyflex sck,
577: per_assignment_status_types ast
578: where aaf.person_id = c_person_id
579: and aaf.assignment_id not in (paaf.assignment_id)
580: and aaf.effective_start_date <= c_end_date-1
581: and aaf.effective_end_date >= c_start_date

Line 650: per_assignment_status_types past

646: --
647: cursor cur_term_asg_dtls(c_person_id number, c_effective_date date) IS
648: select 1
649: from per_all_assignments_f a,
650: per_assignment_status_types past
651: where a.assignment_status_type_id = past.assignment_status_type_id
652: and past.per_system_status = 'TERM_ASSIGN'
653: and a.person_id = c_person_id
654: and c_effective_date between a.effective_start_date and a.effective_end_date;