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_ITREF_UPLOAD dependencies on DUAL

Line 39: FROM dual;

35: BEGIN
36:
37: SELECT pay_payroll_actions_s.nextval
38: INTO g_payroll_action_id
39: FROM dual;
40:
41: INSERT INTO pay_payroll_actions
42: (payroll_action_id
43: ,action_type

Line 86: FROM dual;

82: BEGIN
83:
84: SELECT pay_action_information_s.nextval
85: INTO l_action_id
86: FROM dual;
87:
88: -- Bug 12991144
89:
90: SELECT DECODE(upper(p_csv_rec.status), 'REGISTERED', 'R', 'EXISTING TAXPAYER', 'E','TAXPAYER TO CONTACT SARS', 'T', 'INSUFFICIENT INFORMATION', 'I', 'NOT VERIFIED', 'NV', 'NON-INDIVIDUAL', 'NI')

Line 90: SELECT DECODE(upper(p_csv_rec.status), 'REGISTERED', 'R', 'EXISTING TAXPAYER', 'E','TAXPAYER TO CONTACT SARS', 'T', 'INSUFFICIENT INFORMATION', 'I', 'NOT VERIFIED', 'NV', 'NON-INDIVIDUAL', 'NI')

86: FROM dual;
87:
88: -- Bug 12991144
89:
90: SELECT DECODE(upper(p_csv_rec.status), 'REGISTERED', 'R', 'EXISTING TAXPAYER', 'E','TAXPAYER TO CONTACT SARS', 'T', 'INSUFFICIENT INFORMATION', 'I', 'NOT VERIFIED', 'NV', 'NON-INDIVIDUAL', 'NI')
91: INTO l_status
92: FROM dual;
93:
94: -- Bug 12991144

Line 92: FROM dual;

88: -- Bug 12991144
89:
90: SELECT DECODE(upper(p_csv_rec.status), 'REGISTERED', 'R', 'EXISTING TAXPAYER', 'E','TAXPAYER TO CONTACT SARS', 'T', 'INSUFFICIENT INFORMATION', 'I', 'NOT VERIFIED', 'NV', 'NON-INDIVIDUAL', 'NI')
91: INTO l_status
92: FROM dual;
93:
94: -- Bug 12991144
95:
96: pay_action_information_api.create_action_information(

Line 289: IF upper(csv_rec.status) in ('TAXPAYER TO CONTACT SARS', 'INSUFFICIENT INFORMATION', 'NOT VERIFIED', 'NON-INDIVIDUAL') THEN

285:
286: -- Bug 12991144
287:
288: -- Checking if the record needs to be processed depending upon the status returned by SARS
289: IF upper(csv_rec.status) in ('TAXPAYER TO CONTACT SARS', 'INSUFFICIENT INFORMATION', 'NOT VERIFIED', 'NON-INDIVIDUAL') THEN
290: hr_utility.set_location('As no data provided by SARS, no need to process csv record of employee number:'||csv_rec.emp_num,52);
291: create_action_information(csv_rec,'NA');
292: ELSIF upper(csv_rec.status) in ('REGISTERED', 'EXISTING TAXPAYER') THEN
293: