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 167: FROM xle_firstparty_information_v xle

163: -- get country code
164:
165: SELECT xle.country
166: INTO l_country
167: FROM xle_firstparty_information_v xle
168: WHERE xle.legal_entity_id = l_legal_entity_id;
169:
170: IF p_reporting_level = 'LEDGER' THEN
171: