DBA Data[Home] [Help]

APPS.BEN_CWB_ASG_UPDATE dependencies on HR_LOOKUPS

Line 157: l_cd_meaning_old hr_lookups.meaning%type;

153:
154: l_txn_new ben_transaction%rowtype;
155: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
156: l_object_version_number ben_cwb_audit.object_version_number%type;
157: l_cd_meaning_old hr_lookups.meaning%type;
158: l_cd_meaning_new hr_lookups.meaning%type;
159: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;

Line 158: l_cd_meaning_new hr_lookups.meaning%type;

154: l_txn_new ben_transaction%rowtype;
155: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
156: l_object_version_number ben_cwb_audit.object_version_number%type;
157: l_cd_meaning_old hr_lookups.meaning%type;
158: l_cd_meaning_new hr_lookups.meaning%type;
159: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
160: l_pl_id ben_cwb_pl_dsgn.pl_id%type;
161: l_lf_evt_ocrd_dt ben_cwb_pl_dsgn.lf_evt_ocrd_dt%type;
162: l_person_id fnd_user.employee_id%type;

Line 181: from hr_lookups

177: --
178: cursor c_lookup(v_lookup_type varchar2
179: ,v_lookup_code varchar2) is
180: select meaning
181: from hr_lookups
182: where lookup_type = v_lookup_type
183: and lookup_code = v_lookup_code;
184: --
185: cursor c_person_id

Line 341: from hr_lookups

337: --
338: cursor c_lookup(v_lookup_type varchar2
339: ,v_lookup_code varchar2) is
340: select meaning
341: from hr_lookups
342: where lookup_type = v_lookup_type
343: and lookup_code = v_lookup_code;
344: --
345: cursor c_person_id is