DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 5419: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5415:
5416:
5417: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
5418: select to_date(attribute_value, 'DD/MM/YYYY')
5419: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5420: where jrr.regime_id = jrd.regime_id
5421: AND jrd.regime_code = jai_constants.service_regime
5422: and jrr.organization_id = p_organization_id
5423: and jrr.location_id = p_location_id

Line 5429: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5425: AND jrr.attribute_type_code = 'OTHERS'
5426: AND jrr.registration_type = 'OTHERS'
5427: AND (NOT EXISTS
5428: (select '1'
5429: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5430: where jrr.regime_id = jrd.regime_id
5431: AND jrd.regime_code = jai_constants.service_regime
5432: and jrr.attribute_code IN 'INV_ORG_CLASSIFICATION'
5433: and jrr.attribute_value <> 'ORGANIZATION'

Line 5439: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

5435: and jrr.location_id = p_location_id)
5436: OR
5437: NOT EXISTS
5438: (select '1'
5439: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5440: where jrr.regime_id = jrd.regime_id
5441: AND jrd.regime_code = jai_constants.service_regime
5442: and jrr.attribute_code IN 'SERVICE TYPE'
5443: and jrr.attribute_value <> 'OTHER'