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 758: per_assignment_status_types past,

754: -- for given assignment on or before the given date
755: CURSOR get_first_active_start IS
756: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id
757: FROM per_all_assignments_f paaf,
758: per_assignment_status_types past,
759: pay_all_payrolls_f papf,
760: hr_soft_coding_keyflex flex
761: WHERE paaf.assignment_id = p_asg_id
762: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 791: per_assignment_status_types past,

787: -- a day before it was transferred to another PAYE Ref
788: CURSOR is_term_and_xfer IS
789: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
790: FROM per_all_assignments_f paaf,
791: per_assignment_status_types past,
792: pay_all_payrolls_f papf,
793: hr_soft_coding_keyflex flex
794: WHERE paaf.assignment_id = p_asg_id
795: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 810: per_assignment_status_types past1,

806: -- assignment but remained active before and after the transfer
807: CURSOR is_another_active_asg_xfer IS
808: SELECT 'Y'
809: FROM per_all_assignments_f paaf1,
810: per_assignment_status_types past1,
811: pay_all_payrolls_f papf1,
812: hr_soft_coding_keyflex flex1
813: WHERE paaf1.period_of_service_id = l_pos_id
814: AND paaf1.assignment_id <> p_asg_id

Line 825: per_assignment_status_types past2,

821: AND papf1.soft_coding_keyflex_id = flex1.soft_coding_keyflex_id
822: AND flex1.segment1 = p_tax_ref
823: AND EXISTS ( SELECT 1
824: FROM per_all_assignments_f paaf2,
825: per_assignment_status_types past2,
826: pay_all_payrolls_f papf2,
827: hr_soft_coding_keyflex flex2
828: WHERE paaf2.assignment_id = paaf1.assignment_id
829: AND l_min_active-1 BETWEEN paaf2.effective_start_date

Line 843: per_assignment_status_types past,

839: -- assignments of the person on a given tax ref as at a given date
840: CURSOR get_agg_min_start_date IS
841: SELECT min(paaf.effective_start_date) min_active
842: FROM per_all_assignments_f paaf,
843: per_assignment_status_types past,
844: pay_all_payrolls_f papf,
845: hr_soft_coding_keyflex flex
846: WHERE paaf.person_id = l_person_id
847: AND (l_min_active-1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 959: per_assignment_status_types past,

955: -- for given assignment
956: CURSOR get_last_active_end IS
957: SELECT max(paaf.effective_end_date) last_end_date, max(person_id) person_id
958: FROM per_all_assignments_f paaf,
959: per_assignment_status_types past,
960: pay_all_payrolls_f papf,
961: hr_soft_coding_keyflex flex
962: WHERE paaf.assignment_id = p_asg_id
963: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 992: per_assignment_status_types past,

988: -- a day before it was transferred to another PAYE Ref
989: CURSOR is_term_and_xfer IS
990: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
991: FROM per_all_assignments_f paaf,
992: per_assignment_status_types past,
993: pay_all_payrolls_f papf,
994: hr_soft_coding_keyflex flex
995: WHERE paaf.assignment_id = p_asg_id
996: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 1011: per_assignment_status_types past1,

1007: -- assignment but remained active before and after the transfer
1008: CURSOR is_another_active_asg_xfer IS
1009: SELECT 'Y'
1010: FROM per_all_assignments_f paaf1,
1011: per_assignment_status_types past1,
1012: pay_all_payrolls_f papf1,
1013: hr_soft_coding_keyflex flex1
1014: WHERE paaf1.period_of_service_id = l_pos_id
1015: AND paaf1.assignment_id <> p_asg_id

Line 1026: per_assignment_status_types past2,

1022: AND papf1.soft_coding_keyflex_id = flex1.soft_coding_keyflex_id
1023: AND flex1.segment1 = p_tax_ref
1024: AND EXISTS ( SELECT 1
1025: FROM per_all_assignments_f paaf2,
1026: per_assignment_status_types past2,
1027: pay_all_payrolls_f papf2,
1028: hr_soft_coding_keyflex flex2
1029: WHERE paaf2.assignment_id = paaf1.assignment_id
1030: AND l_min_active-1 BETWEEN paaf2.effective_start_date

Line 1044: per_assignment_status_types past,

1040: -- assignments of the person on a given tax ref as at a given date
1041: CURSOR get_agg_max_end_date IS
1042: SELECT max(paaf.effective_end_date) max_active
1043: FROM per_all_assignments_f paaf,
1044: per_assignment_status_types past,
1045: pay_all_payrolls_f papf,
1046: hr_soft_coding_keyflex flex
1047: WHERE paaf.person_id = l_person_id
1048: AND (l_max_active+1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 3292: per_assignment_status_types past,

3288: --
3289: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3290: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active
3291: FROM per_all_assignments_f paaf,
3292: per_assignment_status_types past,
3293: pay_all_payrolls_f papf,
3294: hr_soft_coding_keyflex flex
3295: WHERE paaf.assignment_id = p_asg_id
3296: AND paaf.assignment_status_type_id = past.assignment_status_type_id