eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_REMARKS

Line 1272: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE

1268: RETURN(FALSE);
1269:
1270: END segments_defined;
1271:
1272: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1273: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1274: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1275: ,p_effective_date IN DATE)
1276: RETURN VARCHAR2 IS

Line 1273: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE

1269:
1270: END segments_defined;
1271:
1272: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1273: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1274: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1275: ,p_effective_date IN DATE)
1276: RETURN VARCHAR2 IS
1277:

Line 1274: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE

1270: END segments_defined;
1271:
1272: FUNCTION get_noac_remark_req (p_first_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1273: ,p_second_noa_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1274: ,p_remark_id IN ghr_noac_remarks.nature_of_action_id%TYPE
1275: ,p_effective_date IN DATE)
1276: RETURN VARCHAR2 IS
1277:
1278: CURSOR c_ncr IS

Line 1280: FROM ghr_noac_remarks ncr

1276: RETURN VARCHAR2 IS
1277:
1278: CURSOR c_ncr IS
1279: SELECT 1
1280: FROM ghr_noac_remarks ncr
1281: WHERE (ncr.nature_of_action_id = p_first_noa_id
1282: OR ncr.nature_of_action_id = p_second_noa_id)
1283: AND ncr.remark_id = p_remark_id
1284: AND ncr.required_flag = 'Y'