APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 401: l_country xle_firstparty_information_v.country%TYPE;

397:
398: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;
399: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
400: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
401: l_country xle_firstparty_information_v.country%TYPE;
402: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
403: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
404:
405: -- Bug 6835573

Line 668: FROM xle_firstparty_information_v xle

664:
665: -- use TRN/LE to determine the country for which SELECTION is executed.
666: SELECT xle.country
667: INTO l_country
668: FROM xle_firstparty_information_v xle
669: WHERE xle.legal_entity_id = l_global_variables_rec.legal_entity_id;
670:
671:
672: /*-----------------------------------------------------------------------------------------------------+

Line 2864: l_country xle_firstparty_information_v.country%TYPE;

2860: l_trx_date_low DATE;
2861: l_trx_date_high DATE;
2862: l_gl_date_low DATE;
2863: l_gl_date_high DATE;
2864: l_country xle_firstparty_information_v.country%TYPE;
2865:
2866: --Bug6835573
2867: l_reported_status VARCHAR2(20) := 'UNREPORTED';
2868: l_last_start_date DATE;