APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOA_FAMILIES

Line 1318: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE

1314: RETURN(l_ret_val);
1315:
1316: END get_user_person_id;
1317:
1318: PROCEDURE get_single_noac_for_fam (p_noa_family_code IN ghr_noa_families.noa_family_code%TYPE
1319: ,p_effective_date IN DATE
1320: ,p_nature_of_action_id IN OUT NOCOPY ghr_nature_of_actions.nature_of_action_id%TYPE
1321: ,p_code IN OUT NOCOPY ghr_nature_of_actions.code%TYPE
1322: ,p_description IN OUT NOCOPY ghr_nature_of_actions.description%TYPE) IS

Line 1336: ,ghr_noa_families naf

1332: SELECT noa.nature_of_action_id
1333: ,noa.code
1334: ,noa.description
1335: FROM ghr_nature_of_actions noa
1336: ,ghr_noa_families naf
1337: WHERE naf.noa_family_code = p_noa_family_code
1338: AND naf.nature_of_action_id = noa.nature_of_action_id
1339: AND naf.enabled_flag = 'Y'
1340: AND NVL(p_effective_date,trunc(sysdate))

Line 1459: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE)

1455:
1456: END get_restricted_form;
1457:
1458: --
1459: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE)
1460: RETURN VARCHAR2 IS
1461: --
1462: l_ret_val VARCHAR2(30) := NULL;
1463: --

Line 1467: ,ghr_noa_families naf

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';
1471:

Line 1484: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE,

1480:
1481: --
1482: --
1483: -- Bug#3941541 Overloaded function with effective date as another parameter
1484: FUNCTION get_noa_pm_family (p_nature_of_action_id IN ghr_noa_families.nature_of_action_id%TYPE,
1485: p_effective_date IN DATE)
1486: RETURN VARCHAR2 IS
1487: --
1488: l_ret_val VARCHAR2(30) := NULL;

Line 1493: ,ghr_noa_families naf

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'
1497: AND p_effective_date between NVL(naf.start_date_active,p_effective_date)

Line 1520: ,ghr_noa_families naf

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
1524: AND noa.code = p_noa_code