APPS.CZ_IMP_SINGLE dependencies on CZ_UI_TYPEDPSN_V

Line 3737: TYPE tUIDetailedTypeTbl IS TABLE OF CZ_UI_TYPEDPSN_V.detailed_type_id%TYPE INDEX BY VARCHAR2(15);-- kdande; Bug 6885757; 12-Mar-2008

3733: COPY_ROOT_MODEL IN VARCHAR2,
3734: sExpl_type IN VARCHAR2,dRev_date IN DATE,
3735: x_run_id OUT NOCOPY NUMBER) IS
3736:
3737: TYPE tUIDetailedTypeTbl IS TABLE OF CZ_UI_TYPEDPSN_V.detailed_type_id%TYPE INDEX BY VARCHAR2(15);-- kdande; Bug 6885757; 12-Mar-2008
3738:
3739: genRun_ID PLS_INTEGER;
3740: nCommit_size PLS_INTEGER DEFAULT 1;
3741: nMax_err PLS_INTEGER DEFAULT 10000;

Line 4165: FROM CZ_UI_TYPEDPSN_V

4161: LOOP
4162: l_compare_detailed_types := TRUE;
4163: l_current_date := SYSDATE;
4164: FOR i IN (SELECT ps_node_id, detailed_type_id
4165: FROM CZ_UI_TYPEDPSN_V
4166: WHERE devl_project_Id = model.component_id
4167: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)
4168: AND deleted_flag = '0')
4169: LOOP

Line 4315: FROM CZ_UI_TYPEDPSN_V

4311:
4312: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID
4313: AND rec_status = 'OK')LOOP
4314: FOR i IN (SELECT ps_node_id, detailed_type_id
4315: FROM CZ_UI_TYPEDPSN_V
4316: WHERE devl_project_Id = model.devl_project_id
4317: AND ps_node_type IN (CZ_TYPES.PS_NODE_TYPE_BOM_MODEL, CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS)
4318: AND creation_date <= l_current_date
4319: AND deleted_flag = '0')