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

Line 734: per_assignment_status_types past,

730: -- for given assignment on or before the given date
731: CURSOR get_first_active_start IS
732: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id
733: FROM per_all_assignments_f paaf,
734: per_assignment_status_types past,
735: pay_all_payrolls_f papf,
736: hr_soft_coding_keyflex flex
737: WHERE paaf.assignment_id = p_asg_id
738: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 767: per_assignment_status_types past,

763: -- a day before it was transferred to another PAYE Ref
764: CURSOR is_term_and_xfer IS
765: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
766: FROM per_all_assignments_f paaf,
767: per_assignment_status_types past,
768: pay_all_payrolls_f papf,
769: hr_soft_coding_keyflex flex
770: WHERE paaf.assignment_id = p_asg_id
771: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 786: per_assignment_status_types past1,

782: -- assignment but remained active before and after the transfer
783: CURSOR is_another_active_asg_xfer IS
784: SELECT 'Y'
785: FROM per_all_assignments_f paaf1,
786: per_assignment_status_types past1,
787: pay_all_payrolls_f papf1,
788: hr_soft_coding_keyflex flex1
789: WHERE paaf1.period_of_service_id = l_pos_id
790: AND paaf1.assignment_id <> p_asg_id

Line 801: per_assignment_status_types past2,

797: AND papf1.soft_coding_keyflex_id = flex1.soft_coding_keyflex_id
798: AND flex1.segment1 = p_tax_ref
799: AND EXISTS ( SELECT 1
800: FROM per_all_assignments_f paaf2,
801: per_assignment_status_types past2,
802: pay_all_payrolls_f papf2,
803: hr_soft_coding_keyflex flex2
804: WHERE paaf2.assignment_id = paaf1.assignment_id
805: AND l_min_active-1 BETWEEN paaf2.effective_start_date

Line 819: per_assignment_status_types past,

815: -- assignments of the person on a given tax ref as at a given date
816: CURSOR get_agg_min_start_date IS
817: SELECT min(paaf.effective_start_date) min_active
818: FROM per_all_assignments_f paaf,
819: per_assignment_status_types past,
820: pay_all_payrolls_f papf,
821: hr_soft_coding_keyflex flex
822: WHERE paaf.person_id = l_person_id
823: AND (l_min_active-1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 935: per_assignment_status_types past,

931: -- for given assignment
932: CURSOR get_last_active_end IS
933: SELECT max(paaf.effective_end_date) last_end_date, max(person_id) person_id
934: FROM per_all_assignments_f paaf,
935: per_assignment_status_types past,
936: pay_all_payrolls_f papf,
937: hr_soft_coding_keyflex flex
938: WHERE paaf.assignment_id = p_asg_id
939: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 968: per_assignment_status_types past,

964: -- a day before it was transferred to another PAYE Ref
965: CURSOR is_term_and_xfer IS
966: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
967: FROM per_all_assignments_f paaf,
968: per_assignment_status_types past,
969: pay_all_payrolls_f papf,
970: hr_soft_coding_keyflex flex
971: WHERE paaf.assignment_id = p_asg_id
972: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 987: per_assignment_status_types past1,

983: -- assignment but remained active before and after the transfer
984: CURSOR is_another_active_asg_xfer IS
985: SELECT 'Y'
986: FROM per_all_assignments_f paaf1,
987: per_assignment_status_types past1,
988: pay_all_payrolls_f papf1,
989: hr_soft_coding_keyflex flex1
990: WHERE paaf1.period_of_service_id = l_pos_id
991: AND paaf1.assignment_id <> p_asg_id

Line 1002: per_assignment_status_types past2,

998: AND papf1.soft_coding_keyflex_id = flex1.soft_coding_keyflex_id
999: AND flex1.segment1 = p_tax_ref
1000: AND EXISTS ( SELECT 1
1001: FROM per_all_assignments_f paaf2,
1002: per_assignment_status_types past2,
1003: pay_all_payrolls_f papf2,
1004: hr_soft_coding_keyflex flex2
1005: WHERE paaf2.assignment_id = paaf1.assignment_id
1006: AND l_min_active-1 BETWEEN paaf2.effective_start_date

Line 1020: per_assignment_status_types past,

1016: -- assignments of the person on a given tax ref as at a given date
1017: CURSOR get_agg_max_end_date IS
1018: SELECT max(paaf.effective_end_date) max_active
1019: FROM per_all_assignments_f paaf,
1020: per_assignment_status_types past,
1021: pay_all_payrolls_f papf,
1022: hr_soft_coding_keyflex flex
1023: WHERE paaf.person_id = l_person_id
1024: AND (l_max_active+1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 3165: per_assignment_status_types past,

3161: --
3162: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3163: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active
3164: FROM per_all_assignments_f paaf,
3165: per_assignment_status_types past,
3166: pay_all_payrolls_f papf,
3167: hr_soft_coding_keyflex flex
3168: WHERE paaf.assignment_id = p_asg_id
3169: AND paaf.assignment_status_type_id = past.assignment_status_type_id