APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_OPERATION_RESOURCES

Line 311: FROM BOM_OPERATION_RESOURCES

307: IS
308: SELECT 'Resource Exist'
309: FROM DUAL
310: WHERE EXISTS ( SELECT NULL
311: FROM BOM_OPERATION_RESOURCES
312: WHERE operation_sequence_id = p_op_seq_id
313: ) ;
314: BEGIN
315:

Line 2356: FROM BOM_OPERATION_RESOURCES

2352: IS
2353: SELECT 'Resource Exist'
2354: FROM DUAL
2355: WHERE EXISTS ( SELECT NULL
2356: FROM BOM_OPERATION_RESOURCES
2357: WHERE operation_sequence_id = p_op_seq_id
2358: ) ;
2359:
2360: CURSOR c_std_sub_res (p_std_op_id NUMBER)

Line 2957: FROM BOM_OPERATION_RESOURCES

2953:
2954: -- Check if Parent Operation has resource
2955: CURSOR l_parents_csr(p_parent_seq_id NUMBER) IS
2956: SELECT 'resources exist' dummy
2957: FROM BOM_OPERATION_RESOURCES
2958: WHERE operation_sequence_id = p_parent_seq_id ;
2959:
2960:
2961: -- Check if Uniqueness