APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 330: FROM JAI_RGM_ORG_REGNS_V accnts

326: cp_organization_id IN NUMBER,
327: cp_location_id IN NUMBER
328: ) IS
329: SELECT accnts.attribute_value
330: FROM JAI_RGM_ORG_REGNS_V accnts
331: WHERE accnts.regime_id = cp_regime_id
332: AND accnts.attribute_code = 'SERVICE_TAX_REVERSAL_TO_UPDATE'
333: AND accnts.registration_type = jai_constants.regn_type_others
334: AND accnts.organization_type = cp_organization_type

Line 1556: FROM JAI_RGM_ORG_REGNS_V a

1552: /*End of Bug# 4286646 */
1553:
1554: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/
1555: SELECT a.organization_id org_id,a.location_id /*Bug 5879769 bduvarag*/
1556: FROM JAI_RGM_ORG_REGNS_V a
1557: WHERE regime_id = cp_regime_id
1558: AND registration_type = jai_constants.regn_type_others
1559: AND attribute_type_code = p_att_type_code--rchandan for bug#4428980
1560: AND organization_type = cp_orgn_type

Line 2309: from JAI_RGM_ORG_REGNS_V

2305: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
2306:
2307: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
2308: select to_date(attribute_value, 'DD/MM/YYYY')
2309: from JAI_RGM_ORG_REGNS_V
2310: where regime_id = (SELECT regime_id
2311: FROM JAI_RGM_DEFINITIONS
2312: WHERE regime_code = jai_constants.service_regime)
2313: and organization_id = p_organization_id

Line 2320: from JAI_RGM_ORG_REGNS_V

2316: AND attribute_type_code = 'OTHERS'
2317: AND registration_type = 'OTHERS'
2318: AND (NOT EXISTS
2319: (select '1'
2320: from JAI_RGM_ORG_REGNS_V
2321: where regime_id = p_regime_id
2322: and attribute_code IN 'INV_ORG_CLASSIFICATION'
2323: and attribute_value <> 'ORGANIZATION'
2324: and organization_id = p_organization_id

Line 2329: from JAI_RGM_ORG_REGNS_V

2325: and location_id = p_location_id)
2326: OR
2327: NOT EXISTS
2328: (select '1'
2329: from JAI_RGM_ORG_REGNS_V
2330: where regime_id = p_regime_id
2331: and attribute_code IN 'SERVICE TYPE'
2332: and attribute_value <> 'OTHER'
2333: and organization_id = p_organization_id

Line 3229: FROM JAI_RGM_ORG_REGNS_V

3225: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
3226:
3227: CURSOR c_same_inv_no(cp_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE , cp_location_id JAI_OM_WSH_LINES_ALL.location_id%TYPE ) IS
3228: SELECT attribute_Value
3229: FROM JAI_RGM_ORG_REGNS_V
3230: WHERE regime_id = p_regime_id
3231: AND attribute_type_code = jai_constants.regn_type_others
3232: AND attribute_code = jai_constants.attr_code_same_inv_no
3233: AND organization_id = cp_organization_id

Line 4586: from JAI_RGM_ORG_REGNS_V

4582: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
4583:
4584: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
4585: select to_date(attribute_value, 'DD/MM/YYYY')
4586: from JAI_RGM_ORG_REGNS_V
4587: where regime_id = (SELECT regime_id
4588: FROM JAI_RGM_DEFINITIONS
4589: WHERE regime_code = jai_constants.service_regime)
4590: and organization_id = p_organization_id

Line 4597: from JAI_RGM_ORG_REGNS_V

4593: AND attribute_type_code = 'OTHERS'
4594: AND registration_type = 'OTHERS'
4595: AND (NOT EXISTS
4596: (select '1'
4597: from JAI_RGM_ORG_REGNS_V
4598: where regime_id = p_regime_id
4599: and attribute_code IN 'INV_ORG_CLASSIFICATION'
4600: and attribute_value <> 'ORGANIZATION'
4601: and organization_id = p_organization_id

Line 4606: from JAI_RGM_ORG_REGNS_V

4602: and location_id = p_location_id)
4603: OR
4604: NOT EXISTS
4605: (select '1'
4606: from JAI_RGM_ORG_REGNS_V
4607: where regime_id = p_regime_id
4608: and attribute_code IN 'SERVICE TYPE'
4609: and attribute_value <> 'OTHER'
4610: and organization_id = p_organization_id