DBA Data[Home] [Help]

APPS.CE_CEXCLEAR_XMLP_PKG dependencies on CE_LOOKUPS

Line 25: CE_LOOKUPS L,

21: ,C_TRANSACTION_TYPE
22: ,C_RECEIPT_TRANSLATION
23: FROM
24: CE_BANK_BRANCHES_V ABB,
25: CE_LOOKUPS L,
26: CE_LOOKUPS L2
27: WHERE ABB.BRANCH_PARTY_ID = P_BANK_BRANCH
28: AND L.LOOKUP_TYPE = 'TRAN_ORG_TYPE'
29: AND L.LOOKUP_CODE = P_TYPE

Line 26: CE_LOOKUPS L2

22: ,C_RECEIPT_TRANSLATION
23: FROM
24: CE_BANK_BRANCHES_V ABB,
25: CE_LOOKUPS L,
26: CE_LOOKUPS L2
27: WHERE ABB.BRANCH_PARTY_ID = P_BANK_BRANCH
28: AND L.LOOKUP_TYPE = 'TRAN_ORG_TYPE'
29: AND L.LOOKUP_CODE = P_TYPE
30: AND L2.LOOKUP_TYPE = 'TRX_TYPE'