APPS.JE_IT_LISTING_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 161: l_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;

157: l_con_cp_elec_desc VARCHAR2(200);
158: l_xml_layout BOOLEAN;
159: l_eft_count NUMBER;
160: p_status_code VARCHAR2(30) := NULL;
161: l_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
162:
163:
164: CURSOR cur_status(P_VAT_REPORTING_ENTITY_ID NUMBER,P_YEAR_OF_DECLARATION NUMBER) IS
165: SELECT status_code

Line 178: FROM jg_zz_vat_rep_entities LEGAL,

174: AND year_of_declaration = P_YEAR_OF_DECLARATION;
175:
176: CURSOR entity_identifier(P_VAT_REPORTING_ENTITY_ID NUMBER) IS
177: SELECT LEGAL.ENTITY_IDENTIFIER,LEGAL.VAT_REPORTING_ENTITY_ID
178: FROM jg_zz_vat_rep_entities LEGAL,
179: jg_zz_vat_rep_entities ACC
180: WHERE ACC.VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
181: AND ((ACC.ENTITY_TYPE_CODE = 'ACCOUNTING'
182: AND ACC.MAPPING_VAT_REP_ENTITY_ID = LEGAL.VAT_REPORTING_ENTITY_ID)

Line 179: jg_zz_vat_rep_entities ACC

175:
176: CURSOR entity_identifier(P_VAT_REPORTING_ENTITY_ID NUMBER) IS
177: SELECT LEGAL.ENTITY_IDENTIFIER,LEGAL.VAT_REPORTING_ENTITY_ID
178: FROM jg_zz_vat_rep_entities LEGAL,
179: jg_zz_vat_rep_entities ACC
180: WHERE ACC.VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
181: AND ((ACC.ENTITY_TYPE_CODE = 'ACCOUNTING'
182: AND ACC.MAPPING_VAT_REP_ENTITY_ID = LEGAL.VAT_REPORTING_ENTITY_ID)
183: OR

Line 799: jg_zz_vat_rep_entities repent ,

795: ap_invoice_lines_all ilitem ,
796: ap_invoice_distributions_all iditem ,
797: ap_suppliers pv ,
798: ap_supplier_sites_all pvs ,
799: jg_zz_vat_rep_entities repent ,
800: zx_rates_b zxrates ,
801: zx_taxes_b zxtaxes ,
802: zx_report_codes_assoc zxass ,
803: (SELECT distinct person_id

Line 997: jg_zz_vat_rep_entities repent,

993: hz_cust_site_uses_all hzcsu,
994: hz_cust_acct_sites_all hzcas,
995: hz_cust_accounts hzca,
996: hz_parties hzp,
997: jg_zz_vat_rep_entities repent,
998: zx_rates_b zxrates,
999: zx_taxes_b zxtaxes,
1000: zx_report_codes_assoc zxass,
1001: ra_cust_trx_types_all rtp

Line 2043: FROM jg_zz_vat_rep_entities repent

2039: CURSOR entity_details IS
2040: SELECT repent.ledger_id,
2041: repent.balancing_segment_value,
2042: gl.chart_of_accounts_id
2043: FROM jg_zz_vat_rep_entities repent
2044: ,gl_ledgers gl
2045: WHERE vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
2046: AND gl.ledger_id = repent.ledger_id;
2047:

Line 2054: FROM jg_zz_vat_rep_entities cfg

2050: SELECT nvl(cfg.legal_entity_id,cfgd.legal_entity_id)
2051: ,nvl(cfg.tax_registration_number,cfgd.tax_registration_number) repent_trn
2052: ,min(glp.start_date)
2053: ,max(glp.end_date)
2054: FROM jg_zz_vat_rep_entities cfg
2055: ,jg_zz_vat_rep_entities cfgd
2056: ,gl_periods glp
2057: WHERE cfg.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
2058: and (

Line 2055: ,jg_zz_vat_rep_entities cfgd

2051: ,nvl(cfg.tax_registration_number,cfgd.tax_registration_number) repent_trn
2052: ,min(glp.start_date)
2053: ,max(glp.end_date)
2054: FROM jg_zz_vat_rep_entities cfg
2055: ,jg_zz_vat_rep_entities cfgd
2056: ,gl_periods glp
2057: WHERE cfg.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
2058: and (
2059: ( cfg.entity_type_code = 'ACCOUNTING'