DBA Data[Home] [Help]

APPS.BEN_CWB_ASG_UPDATE dependencies on HR_LOOKUPS

Line 162: l_cd_meaning_old hr_lookups.meaning%type;

158:
159: l_txn_new ben_transaction%rowtype;
160: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
161: l_object_version_number ben_cwb_audit.object_version_number%type;
162: l_cd_meaning_old hr_lookups.meaning%type;
163: l_cd_meaning_new hr_lookups.meaning%type;
164: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

Line 163: l_cd_meaning_new hr_lookups.meaning%type;

159: l_txn_new ben_transaction%rowtype;
160: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
161: l_object_version_number ben_cwb_audit.object_version_number%type;
162: l_cd_meaning_old hr_lookups.meaning%type;
163: l_cd_meaning_new hr_lookups.meaning%type;
164: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
165: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
166: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
167: l_person_id fnd_user.employee_id%type;

Line 186: from hr_lookups

182: --
183: cursor c_lookup(v_lookup_type varchar2
184: ,v_lookup_code varchar2) is
185: select meaning
186: from hr_lookups
187: where lookup_type = v_lookup_type
188: and lookup_code = v_lookup_code;
189: --
190: cursor c_person_id

Line 346: from hr_lookups

342: --
343: cursor c_lookup(v_lookup_type varchar2
344: ,v_lookup_code varchar2) is
345: select meaning
346: from hr_lookups
347: where lookup_type = v_lookup_type
348: and lookup_code = v_lookup_code;
349: --
350: cursor c_person_id is