APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 395: l_country xle_firstparty_information_v.country%TYPE;

391:
392: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;
393: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
394: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
395: l_country xle_firstparty_information_v.country%TYPE;
396: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
397: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
398:
399: -- Bug 6835573

Line 613: FROM xle_firstparty_information_v xle

609:
610: -- use TRN/LE to determine the country for which SELECTION is executed.
611: SELECT xle.country
612: INTO l_country
613: FROM xle_firstparty_information_v xle
614: WHERE xle.legal_entity_id = l_global_variables_rec.legal_entity_id;
615:
616:
617: /*-----------------------------------------------------------------------------------------------------+

Line 2748: l_country xle_firstparty_information_v.country%TYPE;

2744: l_trx_date_low DATE;
2745: l_trx_date_high DATE;
2746: l_gl_date_low DATE;
2747: l_gl_date_high DATE;
2748: l_country xle_firstparty_information_v.country%TYPE;
2749:
2750: --Bug6835573
2751: l_reported_status VARCHAR2(20) := 'UNREPORTED';
2752: l_last_start_date DATE;