APPS.ZPB_DHMINTERFACE_GRP dependencies on ZPB_BUSAREA_VERSIONS

Line 42: ZPB_BUSAREA_VERSIONS B

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';
46:

Line 332: ZPB_BUSAREA_VERSIONS B

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',
336: 'business_area_id'));

Line 2156: ZPB_BUSAREA_ATTRIBUTES E, ZPB_BUSAREA_VERSIONS F

2152: l_command := 'select D.'||l_dim_column||', ';
2153: end if;
2154: l_command := l_command||'C.ATTRIBUTE_ID, C.ATTRIBUTE_VARCHAR_LABEL
2155: from FEM_DIM_ATTRIBUTES_B C, '||l_dim_mbr_table||' D,
2156: ZPB_BUSAREA_ATTRIBUTES E, ZPB_BUSAREA_VERSIONS F
2157: where C.DIMENSION_ID = '||p_dimension_id||'
2158: and D.PERSONAL_FLAG = ''Y''
2159: and D.CREATED_BY = '||l_apps_id||'
2160: and C.ATTRIBUTE_ID = E.ATTRIBUTE_ID