APPS.QA_PLAN_ELEMENT_API dependencies on PO_RELEASES

Line 1296: FROM po_releases pr

1292: id NUMBER;
1293:
1294: CURSOR c (p_id NUMBER, r_num VARCHAR2) IS
1295: SELECT pr.po_release_id
1296: FROM po_releases pr
1297: WHERE pr.po_header_id = p_id
1298: AND pr.release_num = r_num;
1299:
1300: BEGIN

Line 3002: FROM po_releases pr

2998: wild := value;
2999: -- Bug 4958763. SQL Repository Fix SQL ID: 15009081
3000: /*
3001: sql_string := 'SELECT release_num, release_date
3002: FROM po_releases pr
3003: WHERE pr.release_num like :1
3004: ORDER BY pr.release_num';
3005: */
3006:

Line 3008: FROM po_releases

3004: ORDER BY pr.release_num';
3005: */
3006:
3007: sql_string := 'SELECT release_num, release_date
3008: FROM po_releases
3009: WHERE po_header_id = :1
3010: AND release_num like :2
3011: ORDER BY release_num';
3012:

Line 3046: FROM po_releases pr,

3042: END IF;
3043:
3044: sql_string := 'SELECT DISTINCT to_char(pr.release_num) release_number,
3045: QLTDATE.date_to_user(pr.release_date)
3046: FROM po_releases pr,
3047: po_line_locations_trx_v pll
3048: WHERE pr.po_header_id = :1
3049: AND pr.po_header_id = pll.po_header_id
3050: AND pr.po_release_id = pll.po_release_id