APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_AGE_FCTR

Line 1947: from ben_age_fctr agf

1943: l_dob date;
1944: --
1945: cursor c_agf is
1946: select *
1947: from ben_age_fctr agf
1948: where agf.age_fctr_id = g_parm.age_fctr_id
1949: and agf.business_group_id = g_parm.business_group_id;
1950: --
1951: l_agf c_agf%rowtype;

Line 2325: ben_age_fctr agf,

2321: lsf.mn_los_num,
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

Line 3235: ,ben.age_fctr_id

3231: ,ben.comp_selection_rl
3232: ,ben.actn_typ_id
3233: ,ben.elig_enrol_cd
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

Line 5078: ben_age_fctr agf,

5074: hr_lookups hr5,
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,