APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 103: from JAI_RGM_ORG_REGNS_V

99: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
100:
101: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
102: select to_date(attribute_value, 'DD/MM/YYYY')
103: from JAI_RGM_ORG_REGNS_V
104: where regime_id = p_regime_id
105: and organization_id = p_organization_id
106: and location_id = p_location_id
107: AND attribute_code = 'EFF_DATE_ST_PT'

Line 112: from JAI_RGM_ORG_REGNS_V

108: AND attribute_type_code = 'OTHERS'
109: AND registration_type = 'OTHERS'
110: AND (NOT EXISTS
111: (select '1'
112: from JAI_RGM_ORG_REGNS_V
113: where regime_id = p_regime_id
114: and attribute_code IN 'INV_ORG_CLASSIFICATION'
115: and attribute_value <> 'ORGANIZATION'
116: and organization_id = p_organization_id

Line 121: from JAI_RGM_ORG_REGNS_V

117: and location_id = p_location_id)
118: OR
119: NOT EXISTS
120: (select '1'
121: from JAI_RGM_ORG_REGNS_V
122: where regime_id = p_regime_id
123: and attribute_code IN 'SERVICE TYPE'
124: and attribute_value <> 'OTHER'
125: and organization_id = p_organization_id

Line 1358: from JAI_RGM_ORG_REGNS_V

1354: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
1355:
1356: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
1357: select to_date(attribute_value, 'DD/MM/YYYY')
1358: from JAI_RGM_ORG_REGNS_V
1359: where regime_id = p_regime_id
1360: and organization_id = p_organization_id
1361: and location_id = p_location_id
1362: AND attribute_code = 'EFF_DATE_ST_PT'

Line 1367: from JAI_RGM_ORG_REGNS_V

1363: AND attribute_type_code = 'OTHERS'
1364: AND registration_type = 'OTHERS'
1365: AND (NOT EXISTS
1366: (select '1'
1367: from JAI_RGM_ORG_REGNS_V
1368: where regime_id = p_regime_id
1369: and attribute_code IN 'INV_ORG_CLASSIFICATION'
1370: and attribute_value <> 'ORGANIZATION'
1371: and organization_id = p_organization_id

Line 1376: from JAI_RGM_ORG_REGNS_V

1372: and location_id = p_location_id)
1373: OR
1374: NOT EXISTS
1375: (select '1'
1376: from JAI_RGM_ORG_REGNS_V
1377: where regime_id = p_regime_id
1378: and attribute_code IN 'SERVICE TYPE'
1379: and attribute_value <> 'OTHER'
1380: and organization_id = p_organization_id