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

Line 1086: FROM JAI_RGM_ORG_REGNS_V

1082: lv_debug_info VARCHAR2(2000);
1083:
1084: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
1085: SELECT to_date(attribute_value, 'DD/MM/YYYY')
1086: FROM JAI_RGM_ORG_REGNS_V
1087: WHERE regime_id = p_regime_id
1088: AND organization_id = p_organization_id
1089: AND location_id = p_location_id
1090: AND attribute_code = 'EFF_DATE_ST_PT'

Line 1095: FROM JAI_RGM_ORG_REGNS_V

1091: AND attribute_type_code = 'OTHERS'
1092: AND registration_type = 'OTHERS'
1093: AND (NOT EXISTS
1094: (SELECT '1'
1095: FROM JAI_RGM_ORG_REGNS_V
1096: WHERE regime_id = p_regime_id
1097: AND attribute_code IN 'INV_ORG_CLASSIFICATION'
1098: AND attribute_value <> 'ORGANIZATION'
1099: AND organization_id = p_organization_id

Line 1104: FROM JAI_RGM_ORG_REGNS_V

1100: AND location_id = p_location_id)
1101: OR
1102: NOT EXISTS
1103: (SELECT '1'
1104: FROM JAI_RGM_ORG_REGNS_V
1105: WHERE regime_id = p_regime_id
1106: AND attribute_code IN 'SERVICE TYPE'
1107: AND attribute_value <> 'OTHER'
1108: AND organization_id = p_organization_id