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.JAI_CMN_RG_PERIOD_BALS_PKG dependencies on JAI_CMN_RG_OTHERS

Line 91: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b

87: (cp_organization_id in number, cp_location_id in number, cp_register_type in varchar2,
88: cp_start_date in date, cp_end_date in date, cp_tax_type in varchar2)
89: IS
90: SELECT sum(nvl(b.credit,0) - nvl(b.debit,0)) total_cess
91: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b
92: WHERE a.organization_id = cp_organization_id
93: AND a.location_id = cp_location_id
94: AND a.register_type = cp_register_type
95: AND trunc(a.creation_date) between cp_start_date and cp_end_date

Line 538: from JAI_CMN_RG_OTHERS

534: ln_exc_edu_cess_adj number;
535: ln_cvd_edu_cess_adj number;
536: cursor c_get_cess_rnd_amount(cp_register_id number, cp_tax_type varchar2) is
537: select nvl(credit,0) - nvl(debit,0)
538: from JAI_CMN_RG_OTHERS
539: where source_register_id = cp_register_id
540: and source_type = 1
541: and tax_type = cp_tax_type;
542: /*Bug 5989740 bduvarag*/