DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 2802: , jai_rgm_registrations tax_rgm

2798: INTO
2799: ln_tax_rgm_acc_id
2800: FROM
2801: jai_rgm_definitions rgm_def
2802: , jai_rgm_registrations tax_rgm
2803: , jai_rgm_registrations acc_rgm
2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2805: AND tax_rgm.regime_id = rgm_def.regime_id
2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types

Line 2803: , jai_rgm_registrations acc_rgm

2799: ln_tax_rgm_acc_id
2800: FROM
2801: jai_rgm_definitions rgm_def
2802: , jai_rgm_registrations tax_rgm
2803: , jai_rgm_registrations acc_rgm
2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2805: AND tax_rgm.regime_id = rgm_def.regime_id
2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2807: AND tax_rgm.attribute_code = pv_tax_type

Line 3464: FROM JAI_RGM_REGISTRATIONS reg,

3460:
3461: FUNCTION is_tds_calendar_missing RETURN VARCHAR2 IS
3462: cursor c_check_tds_calendar_setup is
3463: SELECT '1'
3464: FROM JAI_RGM_REGISTRATIONS reg,
3465: jai_rgm_definitions def
3466: WHERE
3467: reg.REGISTRATION_TYPE = 'OTHERS' AND
3468: reg.ATTRIBUTE_CODE = 'TDS_CALENDAR' AND