DBA Data[Home] [Help]

APPS.ZPB_DHMINTERFACE_GRP dependencies on ZPB_BUSAREA_LEDGERS

Line 41: from ZPB_BUSAREA_LEDGERS A,

37: x_business_area_id := sys_context('ZPB_CONTEXT', 'business_area_id');
38:
39: select min(LEDGER_ID)
40: into x_ledger_id
41: from ZPB_BUSAREA_LEDGERS A,
42: ZPB_BUSAREA_VERSIONS B
43: where A.VERSION_ID = B.VERSION_ID
44: and B.BUSINESS_AREA_ID = x_business_area_id
45: and B.VERSION_TYPE = 'R';

Line 331: from ZPB_BUSAREA_LEDGERS A,

327: and E.DEFAULT_VERSION_FLAG = 'Y'
328: and C.ATTRIBUTE_ID = D.ATTRIBUTE_ID
329: and C.VERSION_ID = E.VERSION_ID
330: and C.LEDGER_ID = (select min(LEDGER_ID)
331: from ZPB_BUSAREA_LEDGERS A,
332: ZPB_BUSAREA_VERSIONS B
333: where A.VERSION_ID = B.VERSION_ID
334: and B.VERSION_TYPE = 'R'
335: and B.BUSINESS_AREA_ID = sys_context('ZPB_CONTEXT',