APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_FAMILIES

Line 160: p_noa_family_code ghr_families.noa_family_code%TYPE)

156:
157: END get_lookup_description;
158:
159: FUNCTION get_noa_family_name(
160: p_noa_family_code ghr_families.noa_family_code%TYPE)
161: RETURN VARCHAR2 IS
162:
163: l_ret_val ghr_families.name%TYPE := NULL;
164:

Line 163: l_ret_val ghr_families.name%TYPE := NULL;

159: FUNCTION get_noa_family_name(
160: p_noa_family_code ghr_families.noa_family_code%TYPE)
161: RETURN VARCHAR2 IS
162:
163: l_ret_val ghr_families.name%TYPE := NULL;
164:
165: CURSOR cur_fam IS
166: SELECT fam.name
167: FROM ghr_families fam

Line 167: FROM ghr_families fam

163: l_ret_val ghr_families.name%TYPE := NULL;
164:
165: CURSOR cur_fam IS
166: SELECT fam.name
167: FROM ghr_families fam
168: WHERE fam.noa_family_code = p_noa_family_code;
169:
170: BEGIN
171: FOR cur_fam_rec IN cur_fam LOOP

Line 1466: FROM ghr_families fam

1462: l_ret_val VARCHAR2(30) := NULL;
1463: --
1464: CURSOR c_naf IS
1465: SELECT naf.noa_family_code
1466: FROM ghr_families fam
1467: ,ghr_noa_families naf
1468: WHERE fam.noa_family_code = naf.noa_family_code
1469: AND naf.nature_of_action_id = p_nature_of_action_id
1470: AND fam.proc_method_flag = 'Y';

Line 1492: FROM ghr_families fam

1488: l_ret_val VARCHAR2(30) := NULL;
1489: --
1490: CURSOR c_naf IS
1491: SELECT naf.noa_family_code
1492: FROM ghr_families fam
1493: ,ghr_noa_families naf
1494: WHERE fam.noa_family_code = naf.noa_family_code
1495: AND naf.nature_of_action_id = p_nature_of_action_id
1496: AND fam.proc_method_flag = 'Y'

Line 1519: FROM ghr_families fam

1515: l_ret_val VARCHAR2(30) := NULL;
1516: --
1517: CURSOR c_naf IS
1518: SELECT naf.noa_family_code
1519: FROM ghr_families fam
1520: ,ghr_noa_families naf
1521: ,ghr_nature_of_actions noa
1522: WHERE fam.noa_family_code = naf.noa_family_code
1523: AND naf.nature_of_action_id = noa.nature_of_action_id