APPS.GHR_GEN_RPA_NPA dependencies on GHR_REMARKS

Line 195: ghr_remarks remk

191: pre.pa_request_id,
192: remk.code remark_code
193: FROM
194: ghr_pa_remarks pre,
195: ghr_remarks remk
196: WHERE remk.remark_id = pre.remark_id
197: AND pre.pa_request_id = c_pa_request_id;
198:
199: CURSOR c_person_name(p_person_id NUMBER, p_effective_date DATE) IS

Line 1740: ghr_remarks remk

1736: pre.pa_request_id,
1737: remk.code remark_code
1738: FROM
1739: ghr_pa_remarks pre,
1740: ghr_remarks remk
1741: WHERE remk.remark_id = pre.remark_id
1742: AND pre.pa_request_id = c_pa_request_id;
1743:
1744: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS