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_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_TAXES

Line 61: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;

57: ln_surcharge_doc_amt number;
58: ln_surcharge_doc_cess_amt number;
59: ln_surcharge_line_no number;
60: ln_surcharge_cess_line_no number;
61: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:

Line 62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;

58: ln_surcharge_doc_cess_amt number;
59: ln_surcharge_line_no number;
60: ln_surcharge_cess_line_no number;
61: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:
66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;

Line 63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;

59: ln_surcharge_line_no number;
60: ln_surcharge_cess_line_no number;
61: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:
66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
67: ln_currency_code jai_rgm_taxes.currency_code%type;

Line 64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;

60: ln_surcharge_cess_line_no number;
61: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:
66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
67: ln_currency_code jai_rgm_taxes.currency_code%type;
68:

Line 67: ln_currency_code jai_rgm_taxes.currency_code%type;

63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:
66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
67: ln_currency_code jai_rgm_taxes.currency_code%type;
68:
69: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
70: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
71:

Line 73: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;

69: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
70: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
71:
72: -- start, Bgowrava for Forward porting Bug#5989740
73: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;
74: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;
75: ln_surcharge_sh_cess_line_no number;
76: ln_surcharge_doc_sh_cess_amt number;
77: -- end Bgowrava for Forward porting Bug#5989740

Line 74: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;

70: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
71:
72: -- start, Bgowrava for Forward porting Bug#5989740
73: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;
74: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;
75: ln_surcharge_sh_cess_line_no number;
76: ln_surcharge_doc_sh_cess_amt number;
77: -- end Bgowrava for Forward porting Bug#5989740
78:

Line 123: from jai_rgm_taxes

119: is
120: select tax_id
121: ,tax_type
122: ,tax_rate
123: from jai_rgm_taxes
124: where trx_ref_id = ( select max(trx_ref_id)
125: from jai_rgm_refs_all
126: where source_document_id = jai_constants.tcs_surcharge_id
127: and org_tan_no = cp_org_tan_no

Line 1422: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)

1418: from JAI_CMN_CUS_ADDRESSES
1419: where customer_id = cp_customer_id
1420: and confirm_pan = jai_constants.yes;
1421:
1422: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)
1423: is
1424: select sum(rtax.func_tax_amt)
1425: from jai_rgm_taxes rtax
1426: , jai_rgm_refs_all refs

Line 1425: from jai_rgm_taxes rtax

1421:
1422: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)
1423: is
1424: select sum(rtax.func_tax_amt)
1425: from jai_rgm_taxes rtax
1426: , jai_rgm_refs_all refs
1427: where rtax.trx_ref_id = refs.trx_ref_id
1428: and refs.transaction_id = p_transaction_id
1429: and rtax.tax_type = cp_base_tax_type;

Line 1436: from jai_rgm_taxes rtax

1432: ,cp_tax_modified_by varchar2
1433: )
1434: is
1435: select sum(rtax.func_tax_amt)
1436: from jai_rgm_taxes rtax
1437: , jai_rgm_refs_all refs
1438: where rtax.trx_ref_id = refs.trx_ref_id
1439: and rtax.tax_type = cp_tax_type
1440: and refs.transaction_id = p_transaction_id

Line 1453: from jai_rgm_taxes rtax

1449:
1450: cursor c_get_surcharge_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1451: is
1452: select sum(rtax.func_tax_amt)
1453: from jai_rgm_taxes rtax
1454: , jai_rgm_refs_all refs
1455: , JAI_CMN_TAX_CTG_LINES srch
1456: , JAI_CMN_TAX_CTG_LINES srchcess
1457: , JAI_CMN_TAXES_ALL tax

Line 1473: from jai_rgm_taxes rtax

1469:
1470: cursor c_get_surcharge_sh_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1471: is
1472: select sum(rtax.func_tax_amt)
1473: from jai_rgm_taxes rtax
1474: , jai_rgm_refs_all refs
1475: , JAI_CMN_TAX_CTG_LINES srch
1476: , JAI_CMN_TAX_CTG_LINES srchcess
1477: , JAI_CMN_TAXES_ALL tax