APPS.QA_PLAN_ELEMENT_API dependencies on PO_RELEASES

Line 1277: FROM po_releases pr

1273: id NUMBER;
1274:
1275: CURSOR c (p_id NUMBER, r_num VARCHAR2) IS
1276: SELECT pr.po_release_id
1277: FROM po_releases pr
1278: WHERE pr.po_header_id = p_id
1279: AND pr.release_num = r_num;
1280:
1281: BEGIN

Line 2951: FROM po_releases pr

2947: wild := value;
2948: -- Bug 4958763. SQL Repository Fix SQL ID: 15009081
2949: /*
2950: sql_string := 'SELECT release_num, release_date
2951: FROM po_releases pr
2952: WHERE pr.release_num like :1
2953: ORDER BY pr.release_num';
2954: */
2955:

Line 2957: FROM po_releases

2953: ORDER BY pr.release_num';
2954: */
2955:
2956: sql_string := 'SELECT release_num, release_date
2957: FROM po_releases
2958: WHERE po_header_id = :1
2959: AND release_num like :2
2960: ORDER BY release_num';
2961: