DBA Data[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on JMF_GTA_SYSTEM_PARAMETERS_ALL

Line 512: jmf_gta_system_parameters_all sysp

508: CURSOR C_cur IS
509: SELECT
510: sysp.gt_currency_code
511: FROM
512: jmf_gta_system_parameters_all sysp
513: WHERE sysp.org_id = P_Org_Id;
514:
515: CURSOR C_Trx_Ids IS
516: SELECT

Line 2174: jmf_gta_system_parameters_all

2170: SELECT
2171: vat_tax_type_code
2172: ,gt_currency_code
2173: FROM
2174: jmf_gta_system_parameters_all
2175: WHERE org_id=p_org_id;
2176:
2177: --Add this cursor to fix bug 5381833
2178: CURSOR c_not_transferred_ar_lines

Line 3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;

3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;
3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3720:
3721: l_api_name VARCHAR2(50)
3722: :='Generate_Discrepancy_Xml';
3723: l_error_msg VARCHAR2(4000);

Line 3891: jmf_gta_system_parameters_all

3887: CURSOR c_base_currency IS
3888: SELECT
3889: gt_currency_code
3890: FROM
3891: jmf_gta_system_parameters_all
3892: WHERE
3893: org_id=p_org_id;
3894:
3895: