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.PAY_SG_EFT dependencies on PAY_SG_IBG_S

Line 39: ** Instead referred pay_sg_ibg_s.nextval directly in cursor query

35: ** characters of employee_name
36: ** 11 Mar 2003 apunekar 2843503 Modified cursor c_ibg_advice and c_ibg_control for POSB bank .
37: ** 28 May 2003 nanuradh 2920732 Modified the package to use the secured views instead of base tables.
38: ** 17 DEC 2004 agore 4072941 removed function sequence_number
39: ** Instead referred pay_sg_ibg_s.nextval directly in cursor query
40: ** 14 FEB 2007 snimmala 5749324 Included ppa.payroll_action_id join in the cursor c_ibg_advice
41: ** to resolve performance issue.
42: ** 04 AUG 2008 jalin 7296560 Modified to get TRAN_CODE from parameter
43: */

Line 75: , pay_sg_ibg_s.nextval

71: , oea.segment2
72: , 'ORG_NAME=P'
73: , nvl(o.name,'NULL VALUE')
74: , 'SEQ_NO=P'
75: , pay_sg_ibg_s.nextval
76: , 'COMPANY_ID=P'
77: , popm.pmeth_information1
78: , 'PAY_METHOD=P'
79: , popm.org_payment_method_name