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_AE_MIGRATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 37: l_title per_all_assignments_f.title%TYPE;

33: l_segment2 VARCHAR2(30);
34: l_segment3 VARCHAR2(30);
35: l_segment4 VARCHAR2(30);
36: l_segment5 VARCHAR2(30);
37: l_title per_all_assignments_f.title%TYPE;
38: l_same_person NUMBER;
39: i NUMBER;
40: j NUMBER;
41: k NUMBER;

Line 107: FROM per_all_assignments_f paa

103: ,hsc.segment5
104: ,paa.effective_start_date
105: ,paa.effective_end_date
106: ,0 indicator
107: FROM per_all_assignments_f paa
108: ,hr_soft_coding_keyflex hsc
109: WHERE person_id = p_person_id
110: AND paa.primary_flag = 'Y'
111: AND hsc.soft_coding_keyflex_id(+) = paa.soft_coding_keyflex_id

Line 125: FROM per_all_assignments_f paa

121: ,hsc.segment5
122: ,paa.effective_start_date
123: ,paa.effective_end_date
124: ,1 indicator
125: FROM per_all_assignments_f paa
126: ,hr_soft_coding_keyflex hsc
127: WHERE person_id = p_person_id
128: AND paa.primary_flag = 'Y'
129: AND hsc.soft_coding_keyflex_id(+) = paa.soft_coding_keyflex_id