APPS.BEN_BATCH_REPORTING dependencies on HR_LOOKUPS

Line 120: l_mode_cd_lookup_type hr_lookups.lookup_type%type := 'BEN_BENMNGLE_MD';

116: l_proc varchar2(80) := g_package||'.standard_header';
117: l_all varchar2(80);
118: l_none varchar2(80);
119: -- bug 1560336
120: l_mode_cd_lookup_type hr_lookups.lookup_type%type := 'BEN_BENMNGLE_MD';
121: l_drvbl_fctrs_lookup_type hr_lookups.lookup_type%type := 'BEN_DTCT_TMPRL_LER_TYP';
122: l_conc_pgm_name fnd_concurrent_programs.concurrent_program_name%type ;
123: --
124: cursor c_benefit_actions is

Line 121: l_drvbl_fctrs_lookup_type hr_lookups.lookup_type%type := 'BEN_DTCT_TMPRL_LER_TYP';

117: l_all varchar2(80);
118: l_none varchar2(80);
119: -- bug 1560336
120: l_mode_cd_lookup_type hr_lookups.lookup_type%type := 'BEN_BENMNGLE_MD';
121: l_drvbl_fctrs_lookup_type hr_lookups.lookup_type%type := 'BEN_DTCT_TMPRL_LER_TYP';
122: l_conc_pgm_name fnd_concurrent_programs.concurrent_program_name%type ;
123: --
124: cursor c_benefit_actions is
125: select bft.process_date,

Line 168: hr_lookups hr,

164: nvl(pay.payroll_name,l_all),
165: conc.user_concurrent_program_name,
166: fnd1.meaning
167: from ben_benefit_actions bft,
168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,

Line 169: hr_lookups hr1,

165: conc.user_concurrent_program_name,
166: fnd1.meaning
167: from ben_benefit_actions bft,
168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,
173: hr_lookups hr5,

Line 170: hr_lookups hr2,

166: fnd1.meaning
167: from ben_benefit_actions bft,
168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,
173: hr_lookups hr5,
174: fnd_lookups fnd1,

Line 171: hr_lookups hr3,

167: from ben_benefit_actions bft,
168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,
173: hr_lookups hr5,
174: fnd_lookups fnd1,
175: per_people_f ppf,

Line 172: hr_lookups hr4,

168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,
173: hr_lookups hr5,
174: fnd_lookups fnd1,
175: per_people_f ppf,
176: per_person_types ppt,

Line 173: hr_lookups hr5,

169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,
172: hr_lookups hr4,
173: hr_lookups hr5,
174: fnd_lookups fnd1,
175: per_people_f ppf,
176: per_person_types ppt,
177: ben_pgm_f pgm,