APPS.MSC_PQ_UTILS dependencies on MSC_SELECTION_CRITERIA_V

Line 793: FROM msc_selection_criteria_v

789: object_type,
790: lov_type,
791: sequence,
792: object_sequence_id
793: FROM msc_selection_criteria_v
794: WHERE folder_id = p_query_id
795: AND active_flag = 1
796: AND condition IS NOT NULL
797: AND source_type = p_source_type

Line 898: FROM msc_selection_criteria_v

894: object_type,
895: lov_type,
896: sequence,
897: object_sequence_id
898: FROM msc_selection_criteria_v
899: WHERE folder_id = p_query_id
900: AND active_flag = 1
901: AND condition IS NOT NULL
902: ORDER BY source_type, object_type, field_name;

Line 917: FROM msc_selection_criteria_v

913: object_type,
914: lov_type,
915: sequence,
916: object_sequence_id
917: FROM msc_selection_criteria_v
918: WHERE folder_id = p_query_id
919: AND active_flag = 1
920: AND condition IS NOT NULL
921: AND source_type = p_source_type

Line 926: FROM msc_selection_criteria_v

922: AND object_type = p_object_type;
923:
924: CURSOR c_excp_type IS
925: SELECT DISTINCT object_type
926: FROM msc_selection_criteria_v
927: WHERE folder_id = p_query_id
928: AND active_flag = 1
929: AND source_type = p_source_type;
930:

Line 1092: FROM msc_selection_criteria_v

1088: object_type,
1089: lov_type,
1090: sequence,
1091: object_sequence_id
1092: FROM msc_selection_criteria_v
1093: WHERE folder_id = p_query_id
1094: AND active_flag = 1
1095: AND condition IS NOT NULL
1096: AND source_type = p_source_type