APPS.BEN_CWB_AUDIT_API dependencies on HR_LOOKUPS

Line 1145: l_lookup hr_lookups%rowtype;

1141: function return_lookup_validity
1142: (p_lookup_code in varchar2
1143: )return boolean is
1144: l_validity boolean;
1145: l_lookup hr_lookups%rowtype;
1146: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;
1147: l_code_flag code_flag;
1148: l_found boolean;
1149: l_index number;

Line 1192: from hr_lookups

1188: else
1189:
1190: begin
1191: select * into l_lookup
1192: from hr_lookups
1193: where lookup_type='BEN_CWB_AUDIT_TYPE'
1194: and lookup_code = p_lookup_code;
1195:
1196: l_code_flag.code := l_lookup.lookup_code;