APPS.GHR_SS_RPA_CREATION dependencies on GHR_REMARKS

Line 37: FROM GHR_PA_REMARKS parem,GHR_REMARKS rem

33: CURSOR del_exists_rem(p_pa_request_id in number)
34: IS
35: SELECT parem.pa_remark_id,
36: parem.object_version_number
37: FROM GHR_PA_REMARKS parem,GHR_REMARKS rem
38: WHERE parem.pa_request_id = p_pa_request_id
39: AND rem.remark_id = parem.remark_id
40: AND rem.code = 'B51';
41:

Line 1363: p_remark_code in ghr_remarks.code%type) IS

1359:
1360:
1361: PROCEDURE CREATE_PA_REMARKS (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1362: p_effective_date in date,
1363: p_remark_code in ghr_remarks.code%type) IS
1364:
1365: cursor chk_rem_exists(p_remark_id in NUMBER)
1366: is
1367: SELECT 1

Line 1373: l_remark_id ghr_remarks.remark_id%type;

1369: WHERE pa_request_id = p_pa_request_id
1370: AND remark_id = p_remark_id;
1371:
1372: l_proc varchar2(72) := g_package || 'create_remarks';
1373: l_remark_id ghr_remarks.remark_id%type;
1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;