APPS.CZ_PSFT_INTEGRATION_PVT dependencies on CZ_DEVL_PROJECTS

Line 71: from cz_devl_projects prj, cz_model_publications pub

67: v_all_psft_solutions_id_tbl,
68: v_all_psft_solutions_name_tbl,
69: v_all_psft_solutions_desc_tbl,
70: v_all_psft_solutions_prod_tbl
71: from cz_devl_projects prj, cz_model_publications pub
72: where prj.deleted_flag = '0' and prj.product_key like 'PSFT%'
73: and pub.deleted_flag = '0' and pub.object_id = prj.devl_project_id and object_type = 'PRJ'
74: and export_status = 'OK' and source_target_flag = 'T';
75: END load_all_solutions;

Line 1088: FROM cz_devl_projects

1084: l_ndebug:=10;
1085: -- check if config source model as well as all its child models is available
1086: BEGIN
1087: SELECT devl_project_id INTO l_model_id
1088: FROM cz_devl_projects
1089: WHERE devl_project_id = l_model_id AND deleted_flag = '0';
1090: EXCEPTION
1091: WHEN NO_DATA_FOUND THEN
1092: l_model_id := NULL;

Line 1101: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects

1097: SELECT NULL INTO l_model_id
1098: FROM cz_model_ref_expls re
1099: WHERE deleted_flag = '0' AND model_id = l_model_id
1100: AND ps_node_type = PS_NODE_TYPE_REFERENCE
1101: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
1102: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)
1103: AND ROWNUM < 2;
1104:
1105: EXCEPTION