APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 474: JAI_RGM_DEFINITIONS rgms

470: )
471: IS
472: SELECT 1
473: FROM jai_rgm_parties rgmpt,
474: JAI_RGM_DEFINITIONS rgms
475: WHERE rgmpt.regime_id = rgms.regime_id
476: AND rgmpt.location_id = cp_location_id
477: AND rgmpt.organization_id = cp_organization_id
478: AND rgms.regime_code = jai_constants.vat_regime;

Line 1828: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

1824: /** Bgowrava for forward porting Bug#5631784 */
1825: ln_tcs_exists number;
1826: --lv_process_flag jai_constants.successful%type;
1827: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1828: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
1829: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
1830: ln_last_line_no number;
1831: ln_base_line_no number;
1832: lv_context varchar2(240);

Line 1835: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

1831: ln_base_line_no number;
1832: lv_context varchar2(240);
1833: ln_reg_id number;
1834:
1835: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1836: IS
1837: SELECT REGIME_ID
1838: FROM JAI_RGM_DEFINITIONS
1839: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 1838: FROM JAI_RGM_DEFINITIONS

1834:
1835: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1836: IS
1837: SELECT REGIME_ID
1838: FROM JAI_RGM_DEFINITIONS
1839: WHERE REGIME_CODE = CP_REGIME_CODE;
1840:
1841: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
1842: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

Line 1842: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

1838: FROM JAI_RGM_DEFINITIONS
1839: WHERE REGIME_CODE = CP_REGIME_CODE;
1840:
1841: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
1842: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
1843: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE
1844: )
1845: IS
1846: SELECT COUNT(1)