APPS.HZ_DQM_MR_PVT dependencies on HZ_SECONDARY_TRANS

Line 501: FROM hz_secondary_trans st, hz_trans_functions_vl f

497: inner_row_counter := 0;
498:
499: FOR trans in (
500: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
501: FROM hz_secondary_trans st, hz_trans_functions_vl f
502: where f.function_id=st.function_id
503: and st.secondary_attribute_id = attrs.secondary_attribute_id
504: order by transformation_weight desc)
505: LOOP

Line 812: FROM hz_secondary_trans st, hz_trans_functions_vl f

808: inner_row_counter := 0;
809:
810: FOR trans in (
811: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
812: FROM hz_secondary_trans st, hz_trans_functions_vl f
813: where f.function_id=st.function_id
814: and st.secondary_attribute_id = attrs.secondary_attribute_id
815: order by transformation_weight desc)
816: LOOP

Line 1316: FROM hz_secondary_trans st, hz_trans_functions_vl f

1312: inner_row_counter := 0;
1313:
1314: FOR trans in (
1315: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1316: FROM hz_secondary_trans st, hz_trans_functions_vl f
1317: where f.function_id=st.function_id
1318: and st.secondary_attribute_id = attrs.secondary_attribute_id
1319: order by transformation_weight desc)
1320: LOOP

Line 1555: FROM hz_secondary_trans st, hz_trans_functions_vl f

1551: inner_row_counter := 0;
1552:
1553: FOR trans in (
1554: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1555: FROM hz_secondary_trans st, hz_trans_functions_vl f
1556: where f.function_id=st.function_id
1557: and st.secondary_attribute_id = attrs.secondary_attribute_id
1558: order by transformation_weight desc)
1559: LOOP

Line 1851: FROM hz_secondary_trans st, hz_trans_functions_vl f

1847: inner_row_counter := 0;
1848:
1849: FOR trans in (
1850: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1851: FROM hz_secondary_trans st, hz_trans_functions_vl f
1852: where f.function_id=st.function_id
1853: and st.secondary_attribute_id = attrs.secondary_attribute_id
1854: order by transformation_weight desc)
1855: LOOP

Line 2427: FROM hz_secondary_trans st, hz_trans_functions_vl f

2423: inner_row_counter := 0;
2424:
2425: FOR trans in (
2426: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2427: FROM hz_secondary_trans st, hz_trans_functions_vl f
2428: where f.function_id=st.function_id
2429: and st.secondary_attribute_id = attrs.secondary_attribute_id
2430: order by transformation_weight desc)
2431: LOOP

Line 2647: FROM hz_secondary_trans st, hz_trans_functions_vl f

2643: inner_row_counter := 0;
2644:
2645: FOR trans in (
2646: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2647: FROM hz_secondary_trans st, hz_trans_functions_vl f
2648: where f.function_id=st.function_id
2649: and st.secondary_attribute_id = attrs.secondary_attribute_id
2650: order by transformation_weight desc)
2651: LOOP

Line 2937: FROM hz_secondary_trans st, hz_trans_functions_vl f

2933: inner_row_counter := 0;
2934:
2935: FOR trans in (
2936: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2937: FROM hz_secondary_trans st, hz_trans_functions_vl f
2938: where f.function_id=st.function_id
2939: and st.secondary_attribute_id = attrs.secondary_attribute_id
2940: order by transformation_weight desc)
2941: LOOP