APPS.PQH_PA_WHATIF_PROCESS dependencies on HR_LOOKUPS

Line 27: FROM hr_lookups

23: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date) AND nvl(end_date_active,p_effective_date);
24:
25: CURSOR csr_get_nnmntry_uom ( p_nnmntry_uom VARCHAR2, p_effective_date DATE ) IS
26: SELECT meaning
27: FROM hr_lookups
28: WHERE lookup_type= 'BEN_NNMNTRY_UOM'
29: AND lookup_code=p_nnmntry_uom
30: AND enabled_flag = 'Y'
31: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date) AND nvl(end_date_active,p_effective_date);

Line 429: From hr_lookups

425: effective_start_date and effective_end_date;
426:
427: Cursor csr_uom(c_lookup_cd VARCHAR2) IS
428: Select meaning
429: From hr_lookups
430: Where lookup_code=c_lookup_cd
431: and lookup_type='BEN_TM_UOM';
432: --------------------Variables------------------
433: l_proc VARCHAR2(72);

Line 2283: From hr_lookups

2279: ,p_ler_id IN NUMBER) IS
2280: --------------root node label-----------
2281: Cursor csr_root_label IS
2282: Select Meaning
2283: From hr_lookups
2284: Where lookup_type='BEN_SS_DRVD_LABELS'
2285: and lookup_code='COBJ';
2286: ---------------per in ler---------------
2287: CURSOR csr_ler IS

Line 2938: From hr_lookups

2934: ,p_ler_id IN NUMBER) IS
2935: --------------root node label-----------
2936: Cursor csr_root_label IS
2937: Select Meaning
2938: From hr_lookups
2939: Where lookup_type='BEN_SS_DRVD_LABELS'
2940: and lookup_code='COBJ';
2941: ---------------per in ler---------------
2942: CURSOR csr_ler IS