DBA Data[Home] [Help]

APPS.AR_GTA_REPORTS_PKG dependencies on AR_GTA_SYSTEM_PARAMETERS_ALL

Line 576: ar_gta_system_parameters_all sysp

572: CURSOR C_cur IS
573: SELECT
574: sysp.gt_currency_code
575: FROM
576: ar_gta_system_parameters_all sysp
577: WHERE sysp.org_id = P_Org_Id;
578:
579: CURSOR C_Trx_Ids IS
580: SELECT

Line 2289: ar_gta_system_parameters_all

2285: SELECT
2286: vat_tax_type_code
2287: ,gt_currency_code
2288: FROM
2289: ar_gta_system_parameters_all
2290: WHERE org_id=p_org_id;
2291:
2292: --Add this cursor to fix bug 5381833
2293: CURSOR c_not_transferred_ar_lines

Line 3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;

3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;
3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
3899:
3900: l_api_name VARCHAR2(50)
3901: :='Generate_Discrepancy_Xml';
3902: l_error_msg VARCHAR2(4000);

Line 4074: ar_gta_system_parameters_all

4070: CURSOR c_base_currency IS
4071: SELECT
4072: gt_currency_code
4073: FROM
4074: ar_gta_system_parameters_all
4075: WHERE
4076: org_id=p_org_id;
4077:
4078: