APPS.PER_SUCC_MGMT_MIGRATION_PKG dependencies on HR_LOOKUPS

Line 34: FROM hr_lookups h

30: --
31: PROCEDURE check_lookup_mappings(p_business_group_id IN NUMBER,retcode IN OUT NOCOPY NUMBER) IS
32: CURSOR csr_suc_potential(p_bg_id IN NUMBER) IS
33: SELECT rpad(lookup_code,30) LOOKUP_CODE, meaning
34: FROM hr_lookups h
35: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
36: AND lookup_code IN (SELECT distinct pei_information1
37: FROM per_people_extra_info pei,
38: per_all_people_f ppf

Line 44: FROM hr_lookups

40: AND pei.person_id = ppf.person_id
41: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
42: AND ppf.business_group_id = p_bg_id)
43: AND lookup_code NOT IN (SELECT lookup_code
44: FROM hr_lookups
45: WHERE lookup_type = 'READINESS_LEVEL'
46: AND enabled_flag = 'Y'
47: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND NVL(end_date_active,trunc(sysdate)) );
48: CURSOR csr_risk_of_loss(p_bg_id IN NUMBER) IS

Line 50: FROM hr_lookups h

46: AND enabled_flag = 'Y'
47: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND NVL(end_date_active,trunc(sysdate)) );
48: CURSOR csr_risk_of_loss(p_bg_id IN NUMBER) IS
49: SELECT rpad(lookup_code,30) LOOKUP_CODE, meaning
50: FROM hr_lookups h
51: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
52: AND lookup_code IN (SELECT distinct pei_information2
53: FROM per_people_extra_info pei,
54: per_all_people_f ppf

Line 60: FROM hr_lookups

56: AND pei.person_id = ppf.person_id
57: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
58: AND ppf.business_group_id = p_bg_id)
59: AND lookup_code NOT IN (SELECT lookup_code
60: FROM hr_lookups
61: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
62: AND enabled_flag = 'Y'
63: AND trunc(sysdate) BETWEEN nvl(start_date_active,trunc(sysdate)) AND NVL(end_date_active,trunc(sysdate)) );
64: counter NUMBER;