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 1060: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980

1056: FROM JAI_RGM_STL_BALANCES
1057: WHERE settlement_id = pn_settlement_id
1058: GROUP BY party_id,location_id,tax_type;
1059:
1060: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980
1061: SELECT attribute_sequence, attribute_code tax_type, RATE
1062: FROM JAI_RGM_REGISTRATIONS
1063: WHERE regime_id = pn_regime_id
1064: AND registration_type = p_reg_type--rchandan for bug#4428980

Line 1062: FROM JAI_RGM_REGISTRATIONS

1058: GROUP BY party_id,location_id,tax_type;
1059:
1060: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE )IS --rchandan for bug#4428980
1061: SELECT attribute_sequence, attribute_code tax_type, RATE
1062: FROM JAI_RGM_REGISTRATIONS
1063: WHERE regime_id = pn_regime_id
1064: AND registration_type = p_reg_type--rchandan for bug#4428980
1065: ORDER BY 1 ASC;
1066:

Line 1099: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;

1095: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
1096: ln_amount jai_rgm_stl_balances.debit_balance%TYPE;
1097: ln_amount1 jai_rgm_stl_balances.debit_balance%TYPE;
1098: ln_amount2 jai_rgm_stl_balances.debit_balance%TYPE;
1099: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;
1100: v_open_period gl_period_statuses.period_name%type;
1101: v_open_gl_date date;
1102: lv_inv_exists varchar2(1) := 'N' ; -- Bug 4929081
1103: req_id NUMBER;

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

1740: SELECT *
1741: FROM jai_rgm_settlements
1742: WHERE settlement_id = pn_settlement_id;
1743:
1744: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE ) IS --rchandan for bug#4428980
1745: SELECT attribute_sequence, attribute_code tax_type, RATE
1746: FROM JAI_RGM_REGISTRATIONS
1747: WHERE regime_id = pn_regime_id
1748: AND registration_type = p_reg_type --rchandan for bug#4428980

Line 1746: FROM JAI_RGM_REGISTRATIONS

1742: WHERE settlement_id = pn_settlement_id;
1743:
1744: CURSOR cur_tax_types(p_reg_type jai_rgm_registrations.registration_type%TYPE ) IS --rchandan for bug#4428980
1745: SELECT attribute_sequence, attribute_code tax_type, RATE
1746: FROM JAI_RGM_REGISTRATIONS
1747: WHERE regime_id = pn_regime_id
1748: AND registration_type = p_reg_type --rchandan for bug#4428980
1749: ORDER BY 1 ASC;
1750:

Line 1784: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;

1780: lv_tax_type1 jai_rgm_stl_balances.tax_type%TYPE;
1781: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
1782: ln_amount1 jai_rgm_stl_balances.debit_balance%TYPE;
1783: ln_amount2 jai_rgm_stl_balances.debit_balance%TYPE;
1784: ln_rate JAI_RGM_REGISTRATIONS.rate%TYPE;
1785: ln_org_id jai_rgm_stl_balances.party_id%TYPE;
1786: ln_amount jai_rgm_stl_balances.debit_balance%TYPE;
1787: lv_tax_type jai_rgm_stl_balances.tax_type%TYPE;
1788: