eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 1625: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980

1621: FROM JAI_RGM_STL_BALANCES
1622: WHERE settlement_id = pn_settlement_id
1623: GROUP BY party_id,location_id,tax_type;
1624:
1625: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980
1626: SELECT attribute_sequence, attribute_code tax_type, RATE
1627: FROM JAI_RGM_REGISTRATIONS
1628: WHERE regime_id = pn_regime_id
1629: AND registration_type = p_reg_type--rchandan for bug#4428980

Line 1627: FROM JAI_RGM_REGISTRATIONS

1623: GROUP BY party_id,location_id,tax_type;
1624:
1625: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980
1626: SELECT attribute_sequence, attribute_code tax_type, RATE
1627: FROM JAI_RGM_REGISTRATIONS
1628: WHERE regime_id = pn_regime_id
1629: AND registration_type = p_reg_type--rchandan for bug#4428980
1630: ORDER BY 1 ASC;
1631:

Line 1664: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;

1660: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
1661: ln_amount jai_rgm_stl_balances.debit_balance%TYPE;
1662: ln_amount1 jai_rgm_stl_balances.debit_balance%TYPE;
1663: ln_amount2 jai_rgm_stl_balances.debit_balance%TYPE;
1664: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;
1665: v_open_period gl_period_statuses.period_name%type;
1666: v_open_gl_date date;
1667: lv_inv_exists varchar2(1) := 'N' ; -- Bug 4929081
1668: req_id NUMBER;

Line 2352: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE ) IS --rchandan for bug#4428980

2348: SELECT *
2349: FROM jai_rgm_settlements
2350: WHERE settlement_id = pn_settlement_id;
2351:
2352: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE ) IS --rchandan for bug#4428980
2353: SELECT attribute_sequence, attribute_code tax_type, RATE
2354: FROM JAI_RGM_REGISTRATIONS
2355: WHERE regime_id = pn_regime_id
2356: AND registration_type = p_reg_type --rchandan for bug#4428980

Line 2354: FROM JAI_RGM_REGISTRATIONS

2350: WHERE settlement_id = pn_settlement_id;
2351:
2352: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE ) IS --rchandan for bug#4428980
2353: SELECT attribute_sequence, attribute_code tax_type, RATE
2354: FROM JAI_RGM_REGISTRATIONS
2355: WHERE regime_id = pn_regime_id
2356: AND registration_type = p_reg_type --rchandan for bug#4428980
2357: ORDER BY 1 ASC;
2358:

Line 2392: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;

2388: lv_tax_type1 jai_rgm_stl_balances.tax_type%TYPE;
2389: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
2390: ln_amount1 jai_rgm_stl_balances.debit_balance%TYPE;
2391: ln_amount2 jai_rgm_stl_balances.debit_balance%TYPE;
2392: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;
2393: ln_org_id jai_rgm_stl_balances.party_id%TYPE;
2394: ln_amount jai_rgm_stl_balances.debit_balance%TYPE;
2395: lv_tax_type jai_rgm_stl_balances.tax_type%TYPE;
2396: