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_AR_EER1_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 1570: FROM JAI_CMN_RG_PLA_TRXS

1566:
1567: CURSOR get_pla_amount
1568: IS
1569: SELECT round(nvl(sum(nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0)),0),0)
1570: FROM JAI_CMN_RG_PLA_TRXS
1571: WHERE organization_id = p_organization_id
1572: AND location_id = p_location_id
1573: AND trunc(creation_date) >= p_start_date
1574: AND trunc(creation_date) <= trunc(nvl(p_end_date,sysdate))

Line 1600: FROM JAI_CMN_RG_PLA_TRXS

1596: FROM JAI_CMN_RG_OTHERS
1597: WHERE source_type=2
1598: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
1599: AND source_register_id in ( SELECT register_id
1600: FROM JAI_CMN_RG_PLA_TRXS
1601: WHERE organization_id = p_organization_id
1602: AND location_id = p_location_id
1603: AND trunc(creation_date) >= p_start_date
1604: AND trunc(creation_date) <= trunc(nvl(p_end_date,sysdate))

Line 2027: FROM JAI_CMN_RG_PLA_TRXS

2023: FROM JAI_CMN_RG_OTHERS
2024: WHERE source_type=2
2025: AND tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess )
2026: AND source_register_id in ( SELECT register_id
2027: FROM JAI_CMN_RG_PLA_TRXS
2028: WHERE organization_id = p_organization_id
2029: AND location_id = p_location_id
2030: AND trunc(creation_date) >= p_start_date
2031: AND trunc(creation_date) <= trunc(nvl(p_end_date,sysdate))