DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_PRE_REP_PROC_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;

116: AND ZX.entity_code = JGTRD.entity_code
117: AND ZX.event_class_code = JGTRD.event_class_code
118: AND rownum=1;
119:
120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;
121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;

Line 188: FROM xle_firstparty_information_v xle

184: -- get country code
185:
186: SELECT xle.country
187: INTO l_country
188: FROM xle_firstparty_information_v xle
189: WHERE xle.legal_entity_id = l_legal_entity_id;
190:
191: IF p_reporting_level = 'LEDGER' THEN
192: