APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on HR_LOOKUPS

Line 58: hr_lookups hl

54: null Information8
55: from BEN_PLIP_F plip,
56: BEN_PL_F PLN,
57: ben_pl_typ_f ptp,
58: hr_lookups hl
59: where ( C_PLIP_ID is not null and plip.PLIP_ID = C_PLIP_ID )
60: and plip.pl_id=pln.pl_id
61: and pln.pl_typ_id = ptp.pl_typ_id
62: and pln.pl_cd = hl.lookup_code

Line 71: hr_lookups hl

67: hl.meaning Plan_Usage,
68: 'PLNIP' Information8
69: from BEN_PL_F PLN,
70: ben_pl_typ_f ptp,
71: hr_lookups hl
72: where ( C_PL_ID is not null and pln.PL_ID = C_PL_ID )
73: and pln.pl_typ_id = ptp.pl_typ_id
74: and pln.pl_cd = hl.lookup_code
75: and hl.lookup_type = 'BEN_PL' ;

Line 1352: l_pl_usage hr_lookups.meaning%type;

1348: L_DSGN_RQMT_RLSHP_TYP_ID number(15);
1349: L_OUT_DRR_RESULT_ID number(15);
1350: --
1351: l_pl_typ_name ben_pl_typ_f.name%type;
1352: l_pl_usage hr_lookups.meaning%type;
1353: l_group_pl_id number (15);
1354: begin
1355: --
1356: --

Line 9210: FROM hr_lookups hl,

9206: );
9207: --
9208: cursor c_abs_reason(cv_lookup_code in varchar2, cv_effective_date in date) is
9209: SELECT distinct hl.meaning
9210: FROM hr_lookups hl,
9211: per_abs_attendance_reasons abs
9212: WHERE hl.lookup_type = 'ABSENCE_REASON'
9213: AND hl.lookup_code = abs.name
9214: AND hl.lookup_code = cv_lookup_code