APPS.PV_OPP_MATCH_PUB dependencies on DUAL

Line 2343: FROM dual) a

2339: INTO l_dup_count
2340: FROM (
2341: SELECT COUNT(*)
2342: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2343: FROM dual) a
2344: WHERE ROWNUM < 2
2345: GROUP BY concat_value_str
2346: HAVING COUNT(*) > 1) b;
2347:

Line 2395: FROM dual) a

2391:
2392: FOR x IN (
2393: SELECT *
2394: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2395: FROM dual) a
2396: ORDER BY concat_value_str DESC)
2397: LOOP
2398: x_partner_tbl(l_index) := x.party_id;
2399: --Debug(x.party_id || ':::' || x.concat_value_str);

Line 2414: FROM dual) a

2410: -- ------------------------------------------------------------
2411: FOR x IN (
2412: SELECT *
2413: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2414: FROM dual) a
2415: ORDER BY concat_value_str DESC, idx ASC)
2416: LOOP
2417: x_partner_tbl(l_index) := x.party_id;
2418: --Debug(x.party_id || ':::' || x.concat_value_str);