APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1335: FROM JAI_RGM_DEFINITIONS

1331: select to_date(attribute_value, 'DD/MM/YYYY')
1332: from JAI_RGM_ORG_REGNS_V
1333: where regime_id =
1334: (SELECT regime_id
1335: FROM JAI_RGM_DEFINITIONS
1336: WHERE regime_code = jai_constants.service_regime)
1337: and organization_id = p_organization_id
1338: and location_id = p_location_id
1339: AND attribute_code = 'EFF_DATE_ST_PT'

Line 1522: from JAI_RGM_DEFINITIONS

1518:
1519:
1520: cursor cur_regime_code is
1521: select regime_code
1522: from JAI_RGM_DEFINITIONS
1523: where regime_id = pn_regime_id;
1524:
1525: r_rec c_rev_chg%rowtype;
1526: ln_recovery_amount NUMBER;

Line 1527: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;

1523: where regime_id = pn_regime_id;
1524:
1525: r_rec c_rev_chg%rowtype;
1526: ln_recovery_amount NUMBER;
1527: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;
1528: lv_organization_type VARCHAR2(10);
1529: ln_charge_accounting_id NUMBER;
1530: BEGIN
1531: pv_process_flag := 'SS' ;

Line 1668: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

1664: ln_entered_cr NUMBER;
1665: ln_accounted_dr NUMBER;
1666: ln_accounted_cr NUMBER;
1667:
1668: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
1669: lv_reference_name VARCHAR2(30);
1670: ln_reference_id NUMBER(15);
1671: lv_gl_je_category varchar2(30);
1672: lv_status gl_interface.status%TYPE ;

Line 1845: JAI_RGM_DEFINITIONS jrd

1841:
1842: CURSOR c_settle IS
1843: SELECT jrs.*
1844: FROM JAI_RGM_SETTLEMENTS jrs,
1845: JAI_RGM_DEFINITIONS jrd
1846: where jrs.regime_id = jrd.regime_id
1847: and jrd.regime_code = jai_constants.service_regime
1848: and jrs.payment_date between p_from_date and p_to_date
1849: and jrs.status = 'SETTLED';

Line 1889: from JAI_RGM_DEFINITIONS

1885: jrr.settlement_id;
1886:
1887: cursor cur_regime_code is
1888: select regime_code
1889: from JAI_RGM_DEFINITIONS
1890: where regime_id = p_regime_id;
1891:
1892: CURSOR c_get_curr_dtls (pn_invoice_id NUMBER) IS
1893: SELECT payment_currency_code,

Line 1954: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;

1950:
1951: r_sel c_settle%rowtype;
1952: r_rec c_rev_chg%rowtype;
1953: r_curr_dtls c_get_curr_dtls%rowtype;
1954: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;
1955: ln_recovery_amount NUMBER;
1956: lv_organization_type VARCHAR2(10);
1957: lv_process_flag VARCHAR2(15);
1958: lv_process_message VARCHAR2(4000);