[Home] [Help]
2130: -- This procedure processes the person's length of service.
2131: --
2132: cursor c_lsf is
2133: select *
2134: from ben_los_fctr los
2135: where los.los_fctr_id = g_parm.los_fctr_id
2136: and los.business_group_id = g_parm.business_group_id;
2137: --
2138: l_lsf c_lsf%rowtype;
2322: lsf.mx_los_num,
2323: lsf.los_det_cd
2324: from ben_cmbn_age_los_fctr cal,
2325: ben_age_fctr agf,
2326: ben_los_fctr lsf
2327: where cal.cmbn_age_los_fctr_id = g_parm.cmbn_age_los_fctr_id
2328: and cal.business_group_id = g_parm.business_group_id
2329: and cal.age_fctr_id = agf.age_fctr_id
2330: and agf.business_group_id = g_parm.business_group_id
3234: ,ben.use_fctr_to_sel_flag
3235: ,ben.age_fctr_id
3236: ,ben.min_age
3237: ,ben.max_age
3238: ,ben.los_fctr_id
3239: ,ben.min_los
3240: ,ben.max_los
3241: ,ben.los_det_to_use_cd
3242: ,ben.cmbn_age_los_fctr_id
5075: hr_lookups hr6,
5076: hr_lookups hr7,
5077: fnd_lookups fnd1,
5078: ben_age_fctr agf,
5079: ben_los_fctr los,
5080: ben_cmbn_age_los_fctr cla,
5081: ben_cm_typ_f cct,
5082: ben_actn_typ actn,
5083: per_people_f ppf,