DBA Data[Home] [Help]

APPS.JE_JEITXLRG_XMLP_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 37: JG_ZZ_VAT_REP_ENTITIES A,

33: NVL(A.LEGAL_ENTITY_ID
34: ,B.LEGAL_ENTITY_ID)
35: INTO P_LEGAL_ENTITY_ID
36: FROM
37: JG_ZZ_VAT_REP_ENTITIES A,
38: JG_ZZ_VAT_REP_ENTITIES B
39: WHERE A.MAPPING_VAT_REP_ENTITY_ID = B.VAT_REPORTING_ENTITY_ID (+)
40: AND A.VAT_REPORTING_ENTITY_ID = P_REP_IDENTIFIER;
41: SELECT

Line 38: JG_ZZ_VAT_REP_ENTITIES B

34: ,B.LEGAL_ENTITY_ID)
35: INTO P_LEGAL_ENTITY_ID
36: FROM
37: JG_ZZ_VAT_REP_ENTITIES A,
38: JG_ZZ_VAT_REP_ENTITIES B
39: WHERE A.MAPPING_VAT_REP_ENTITY_ID = B.VAT_REPORTING_ENTITY_ID (+)
40: AND A.VAT_REPORTING_ENTITY_ID = P_REP_IDENTIFIER;
41: SELECT
42: count(*)