APPS.GHR_GEN_RPA_NPA dependencies on GHR_REMARKS

Line 145: ghr_remarks remk

141: pre.pa_request_id,
142: remk.code remark_code
143: FROM
144: ghr_pa_remarks pre,
145: ghr_remarks remk
146: WHERE remk.remark_id = pre.remark_id
147: AND pre.pa_request_id = c_pa_request_id;
148:
149: CURSOR c_person_name(p_person_id NUMBER, p_effective_date DATE) IS

Line 1507: ghr_remarks remk

1503: pre.pa_request_id,
1504: remk.code remark_code
1505: FROM
1506: ghr_pa_remarks pre,
1507: ghr_remarks remk
1508: WHERE remk.remark_id = pre.remark_id
1509: AND pre.pa_request_id = c_pa_request_id;
1510:
1511: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS