APPS.FEM_CONDITIONS_API dependencies on FEM_COND_DIM_CMP_DTL

Line 1456: FROM fem_cond_dim_cmp_dtl

1452:
1453:
1454: CURSOR getDimAttrs IS
1455: SELECT DISTINCT dim_attr_varchar_label
1456: FROM fem_cond_dim_cmp_dtl
1457: WHERE cond_dim_cmp_obj_def_id = p_dimComponentDefId;
1458:
1459: l_stepSpecificString LONG;
1460: l_attrString LONG;

Line 1481: FROM fem_cond_dim_cmp_dtl

1477:
1478: CURSOR getDimAttrSteps IS
1479: SELECT dim_attr_varchar_label,
1480: dim_attr_value
1481: FROM fem_cond_dim_cmp_dtl
1482: WHERE cond_dim_cmp_obj_def_id = p_dimComponentDefId
1483: AND dim_attr_varchar_label = l_attrVarcharLabel;
1484:
1485: BEGIN

Line 1962: from fem_cond_dim_cmp_dtl

1958: ) IS
1959:
1960: cursor dim_hiers_csr is
1961: select distinct hierarchy_obj_id
1962: from fem_cond_dim_cmp_dtl
1963: where cond_dim_cmp_obj_def_id = p_dimComponentDefId;
1964:
1965: cursor dim_hier_steps_csr (p_hierarchy_obj_id in number) is
1966: select node

Line 1968: from fem_cond_dim_cmp_dtl

1964:
1965: cursor dim_hier_steps_csr (p_hierarchy_obj_id in number) is
1966: select node
1967: ,relation_code
1968: from fem_cond_dim_cmp_dtl
1969: where cond_dim_cmp_obj_def_id = p_dimComponentDefId
1970: and hierarchy_obj_id = p_hierarchy_obj_id;
1971:
1972: -------------------

Line 1975: type node_table is table of fem_cond_dim_cmp_dtl.node%type;

1971:
1972: -------------------
1973: -- Declare Types --
1974: -------------------
1975: type node_table is table of fem_cond_dim_cmp_dtl.node%type;
1976: type relation_code_table is table of fem_cond_dim_cmp_dtl.relation_code%type;
1977:
1978: -----------------------
1979: -- Declare variables --

Line 1976: type relation_code_table is table of fem_cond_dim_cmp_dtl.relation_code%type;

1972: -------------------
1973: -- Declare Types --
1974: -------------------
1975: type node_table is table of fem_cond_dim_cmp_dtl.node%type;
1976: type relation_code_table is table of fem_cond_dim_cmp_dtl.relation_code%type;
1977:
1978: -----------------------
1979: -- Declare variables --
1980: -----------------------