DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PS_PROP_VALS

Line 1053: INSERT INTO CZ_PS_PROP_VALS(

1049: );
1050:
1051: -- copy ps node property values, if any
1052:
1053: INSERT INTO CZ_PS_PROP_VALS(
1054: PS_NODE_ID
1055: ,PROPERTY_ID
1056: ,DATA_VALUE
1057: ,DELETED_FLAG

Line 1078: FROM CZ_PS_PROP_VALS

1074: ,EFF_MASK
1075: ,CHECKOUT_USER
1076: ,NULL
1077: ,DATA_NUM_VALUE
1078: FROM CZ_PS_PROP_VALS
1079: WHERE PS_NODE_ID=l_index
1080: AND DELETED_FLAG='0';
1081:
1082: END LOOP;

Line 8014: FROM cz_ps_prop_vals psp,

8010: AND cz_rp_entries.deleted_flag = '0';
8011:
8012: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8013: FROM (SELECT devl_project_id
8014: FROM cz_ps_prop_vals psp,
8015: cz_ps_nodes ps
8016: WHERE psp.deleted_flag = '0'
8017: AND ps.deleted_flag = '0'
8018: AND ps.ps_node_id = psp.ps_node_id