APPS.BEN_CWB_AUDIT_API dependencies on HR_LOOKUPS

Line 1174: l_lookup hr_lookups%rowtype;

1170: function return_lookup_validity
1171: (p_lookup_code in varchar2
1172: )return boolean is
1173: l_validity boolean;
1174: l_lookup hr_lookups%rowtype;
1175: l_audit_type_cd ben_cwb_audit.audit_type_cd%type;
1176: l_code_flag code_flag;
1177: l_found boolean;
1178: l_index number;

Line 1221: from hr_lookups

1217: else
1218:
1219: begin
1220: select * into l_lookup
1221: from hr_lookups
1222: where lookup_type='BEN_CWB_AUDIT_TYPE'
1223: and lookup_code = p_lookup_code;
1224:
1225: l_code_flag.code := l_lookup.lookup_code;