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.PSP_RBKPAY dependencies on PSP_PAYROLL_LINES

Line 41: SELECT payroll_line_id from psp_payroll_lines

37:
38: --Bug 3950282 : removed the cursor get_payroll_line_csr; Deleting records based on control id's.
39: /*
40: CURSOR get_payroll_line_csr is
41: SELECT payroll_line_id from psp_payroll_lines
42: where payroll_control_id = g_payroll_control_rec.payroll_control_id;
43:
44:
45: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;

Line 127: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id));

123: EXIT when get_payroll_line_csr%NOTFOUND;
124: */
125: delete from psp_sub_line_reasons where payroll_sub_line_id in
126: (select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id in
127: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id));
128:
129: delete from psp_payroll_sub_lines where payroll_line_id in
130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);
131:

Line 130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);

126: (select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id in
127: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id));
128:
129: delete from psp_payroll_sub_lines where payroll_line_id in
130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);
131:
132: delete from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id;
133:
134: --Bug 3950282 : removed the cursor get_payroll_line_csr; Deleting records based on control id's.

Line 132: delete from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id;

128:
129: delete from psp_payroll_sub_lines where payroll_line_id in
130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);
131:
132: delete from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id;
133:
134: --Bug 3950282 : removed the cursor get_payroll_line_csr; Deleting records based on control id's.
135: -- end loop;
136: -- close get_payroll_line_csr;