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

Line 65: per_assignment_status_types_tl

61: 1858619 and merge of both
62: 2117507 current and terminated
63: 2132644 assignments reports
64: L. Kloppers 01-Mar-2001 115.4 Changed
65: per_assignment_status_types_tl
66: back to
67: per_assignment_status_types
68: and use PER_SYSTEM_STATUS
69: i.s.o. USER_STATUS

Line 67: per_assignment_status_types

63: 2132644 assignments reports
64: L. Kloppers 01-Mar-2001 115.4 Changed
65: per_assignment_status_types_tl
66: back to
67: per_assignment_status_types
68: and use PER_SYSTEM_STATUS
69: i.s.o. USER_STATUS
70: L. Kloppers 23-Feb-2001 115.3 Changed
71: per_assignment_status_types

Line 71: per_assignment_status_types

67: per_assignment_status_types
68: and use PER_SYSTEM_STATUS
69: i.s.o. USER_STATUS
70: L. Kloppers 23-Feb-2001 115.3 Changed
71: per_assignment_status_types
72: to
73: per_assignment_status_types_tl
74: L. Kloppers 06-Feb-2001 115.2 Changed "end_date"
75: to "ptp.end_date"

Line 73: per_assignment_status_types_tl

69: i.s.o. USER_STATUS
70: L. Kloppers 23-Feb-2001 115.3 Changed
71: per_assignment_status_types
72: to
73: per_assignment_status_types_tl
74: L. Kloppers 06-Feb-2001 115.2 Changed "end_date"
75: to "ptp.end_date"
76: L. Kloppers 31-Jan-2001 115.1 Changed attribute1
77: to prd_information1

Line 783: , per_assignment_status_types past

779: CURSOR csr_assignment_start_date
780: IS
781: SELECT MIN(per.effective_start_date)
782: FROM per_all_assignments_f per
783: , per_assignment_status_types past
784: WHERE per.assignment_id = p_assignment_id
785: AND per.assignment_status_type_id = past.assignment_status_type_id
786: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
787:

Line 826: , per_assignment_status_types past

822: CURSOR csr_assignment_end_date
823: IS
824: SELECT MAX(per.effective_end_date)
825: FROM per_all_assignments_f per
826: , per_assignment_status_types past
827: WHERE per.assignment_id = p_assignment_id
828: AND per.assignment_status_type_id = past.assignment_status_type_id
829: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
830: