DBA Data[Home] [Help]

APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_CS_DEFN_COLUMN_DTLS_V

Line 2687: FROM msd_cs_defn_column_dtls_v

2683: and cs_definition_id = p_cs_id;
2684:
2685: cursor get_dim_lvl_clmn_name(p_cs_id in number) IS
2686: SELECT planning_view_column_name
2687: FROM msd_cs_defn_column_dtls_v
2688: WHERE column_identifier = upper(p_dim_code)||'_LEVEL_ID'
2689: AND identifier_type = 'DIMENSION_ID'
2690: AND cs_definition_id = p_cs_id;
2691:

Line 2911: FROM msd_cs_defn_column_dtls_v

2907: and cs_definition_id = p_cs_id;
2908:
2909: cursor get_dim_lvl_clmn_name(p_cs_id in number) IS
2910: SELECT planning_view_column_name
2911: FROM msd_cs_defn_column_dtls_v
2912: WHERE column_identifier = upper(p_dim_code)||'_LEVEL_ID'
2913: AND identifier_type = 'DIMENSION_ID'
2914: AND cs_definition_id = p_cs_id;
2915:

Line 3061: FROM msd_cs_defn_column_dtls_v

3057: function get_desig_clmn_name (p_cs_id in number) return VARCHAR2 IS
3058:
3059: CURSOR get_str_name (p_id NUMBER) IS
3060: SELECT planning_view_column_name
3061: FROM msd_cs_defn_column_dtls_v
3062: WHERE cs_definition_id = p_id
3063: AND identifier_type = 'CSIDEN';
3064:
3065: x_str_name varchar2(30);