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 101: per_assignment_status_types_tl

97: 1858619 and merge of both
98: 2117507 current and terminated
99: 2132644 assignments reports
100: L. Kloppers 01-Mar-2001 115.4 Changed
101: per_assignment_status_types_tl
102: back to
103: per_assignment_status_types
104: and use PER_SYSTEM_STATUS
105: i.s.o. USER_STATUS

Line 103: per_assignment_status_types

99: 2132644 assignments reports
100: L. Kloppers 01-Mar-2001 115.4 Changed
101: per_assignment_status_types_tl
102: back to
103: per_assignment_status_types
104: and use PER_SYSTEM_STATUS
105: i.s.o. USER_STATUS
106: L. Kloppers 23-Feb-2001 115.3 Changed
107: per_assignment_status_types

Line 107: per_assignment_status_types

103: per_assignment_status_types
104: and use PER_SYSTEM_STATUS
105: i.s.o. USER_STATUS
106: L. Kloppers 23-Feb-2001 115.3 Changed
107: per_assignment_status_types
108: to
109: per_assignment_status_types_tl
110: L. Kloppers 06-Feb-2001 115.2 Changed "end_date"
111: to "ptp.end_date"

Line 109: per_assignment_status_types_tl

105: i.s.o. USER_STATUS
106: L. Kloppers 23-Feb-2001 115.3 Changed
107: per_assignment_status_types
108: to
109: per_assignment_status_types_tl
110: L. Kloppers 06-Feb-2001 115.2 Changed "end_date"
111: to "ptp.end_date"
112: L. Kloppers 31-Jan-2001 115.1 Changed attribute1
113: to prd_information1

Line 840: , per_assignment_status_types past

836: CURSOR csr_assignment_start_date
837: IS
838: SELECT MIN(per.effective_start_date)
839: FROM per_all_assignments_f per
840: , per_assignment_status_types past
841: WHERE per.assignment_id = p_assignment_id
842: AND per.assignment_status_type_id = past.assignment_status_type_id
843: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
844:

Line 883: , per_assignment_status_types past

879: CURSOR csr_assignment_end_date
880: IS
881: SELECT MAX(per.effective_end_date)
882: FROM per_all_assignments_f per
883: , per_assignment_status_types past
884: WHERE per.assignment_id = p_assignment_id
885: AND per.assignment_status_type_id = past.assignment_status_type_id
886: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
887: