APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOAC_LAS

Line 1379: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE

1375:
1376:
1377: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
1378: -- NOAC, otherwise it returns null
1379: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
1380: ,p_effective_date IN DATE
1381: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
1382: ,p_description IN OUT NOCOPY VARCHAR2) IS
1383:

Line 1381: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE

1377: -- This procedure will return the Legal Authority Code and Description if there is only one for the given
1378: -- NOAC, otherwise it returns null
1379: PROCEDURE get_single_lac_for_noac (p_nature_of_action_id IN ghr_noac_las.nature_of_action_id%TYPE
1380: ,p_effective_date IN DATE
1381: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
1382: ,p_description IN OUT NOCOPY VARCHAR2) IS
1383:
1384: l_lac_code ghr_noac_las.lac_lookup_code%TYPE;
1385: l_description VARCHAR2(240);

Line 1384: l_lac_code ghr_noac_las.lac_lookup_code%TYPE;

1380: ,p_effective_date IN DATE
1381: ,p_lac_code IN OUT NOCOPY ghr_noac_las.lac_lookup_code%TYPE
1382: ,p_description IN OUT NOCOPY VARCHAR2) IS
1383:
1384: l_lac_code ghr_noac_las.lac_lookup_code%TYPE;
1385: l_description VARCHAR2(240);
1386: --
1387: l_record_found BOOLEAN := FALSE;
1388:

Line 1393: ,ghr_noac_las nla

1389: CURSOR cur_nla IS
1390: SELECT hrl.lookup_code
1391: ,hrl.description
1392: FROM hr_lookups hrl
1393: ,ghr_noac_las nla
1394: WHERE nla.nature_of_action_id = p_nature_of_action_id
1395: AND nla.enabled_flag = 'Y'
1396: AND nla.valid_first_lac_flag = 'Y'
1397: AND NVL(p_effective_date,trunc(sysdate))