APPS.ZPB_DHMINTERFACE_GRP dependencies on FEM_OBJECT_DEFINITION_B

Line 703: from FEM_OBJECT_DEFINITION_B

699:
700: begin
701: select EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
702: into l_startDate, l_endDate
703: from FEM_OBJECT_DEFINITION_B
704: where OBJECT_ID = to_number(l_hier)
705: and EFFECTIVE_START_DATE <= sysdate
706: and EFFECTIVE_END_DATE >= sysdate;
707:

Line 724: from FEM_OBJECT_DEFINITION_B

720: m := substr(l_hier, instr(l_hier, 'V')+1);
721: begin
722: select EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
723: into l_startDate, l_endDate
724: from FEM_OBJECT_DEFINITION_B
725: where OBJECT_DEFINITION_ID = m;
726: if (l_startDate < sysdate and l_endDate > sysdate) then
727: --
728: -- Need to make room for the effective version:

Line 747: from FEM_OBJECT_DEFINITION_B

743: if (l_startDate = null) then
744: begin
745: select EFFECTIVE_END_DATE
746: into l_endDate
747: from FEM_OBJECT_DEFINITION_B
748: where OBJECT_ID = to_number(l_femHier);
749: l_startDate := l_endDate+1;
750: l_endDate := l_startDate+1;
751: exception

Line 1980: ' A, '||l_dim_mbr_table||' B, FEM_OBJECT_DEFINITION_B D where ';

1976: l_femHier := l_value;
1977: end if;
1978:
1979: l_command := l_command||' from '||l_dim_hier_table||
1980: ' A, '||l_dim_mbr_table||' B, FEM_OBJECT_DEFINITION_B D where ';
1981: if (l_dim_value_sets = 'Y') then
1982: l_command := l_command||
1983: 'A.CHILD_VALUE_SET_ID = B.VALUE_SET_ID and ';
1984: end if;

Line 2033: ' B, FEM_OBJECT_DEFINITION_B D where ';

2029: end if;
2030: l_command := l_command||' min(A.PARENT_DEPTH_NUM)-1, '||
2031: 'A.CHILD_DEPTH_NUM-1, A.DISPLAY_ORDER_NUM, D.OBJECT_ID from '||
2032: l_dim_hier_table||' A, '||l_dim_mbr_table||
2033: ' B, FEM_OBJECT_DEFINITION_B D where ';
2034: if (l_dim_value_sets = 'Y') then
2035: l_command := l_command||
2036: 'A.CHILD_VALUE_SET_ID = B.VALUE_SET_ID and ';
2037: end if;