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_REVERSE_CHARGE_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1332: from JAI_RGM_ORG_REGNS_V

1328: p_organization_id NUMBER,
1329: p_location_id NUMBER) RETURN DATE IS
1330: CURSOR c_get_st_accrual_date IS
1331: select to_date(attribute_value, 'DD/MM/YYYY')
1332: from JAI_RGM_ORG_REGNS_V
1333: where regime_id =
1334: (SELECT regime_id
1335: FROM JAI_RGM_DEFINITIONS
1336: WHERE regime_code = jai_constants.service_regime)

Line 1344: from JAI_RGM_ORG_REGNS_V

1340: AND attribute_type_code = 'OTHERS'
1341: AND registration_type = 'OTHERS'
1342: AND (NOT EXISTS
1343: (select '1'
1344: from JAI_RGM_ORG_REGNS_V
1345: where regime_id = p_regime_id
1346: and attribute_code IN 'INV_ORG_CLASSIFICATION'
1347: and attribute_value <> 'ORGANIZATION'
1348: and organization_id = p_organization_id

Line 1351: from JAI_RGM_ORG_REGNS_V

1347: and attribute_value <> 'ORGANIZATION'
1348: and organization_id = p_organization_id
1349: and location_id = p_location_id) OR NOT EXISTS
1350: (select '1'
1351: from JAI_RGM_ORG_REGNS_V
1352: where regime_id = p_regime_id
1353: and attribute_code IN 'SERVICE TYPE'
1354: and attribute_value <> 'OTHER'
1355: and organization_id = p_organization_id