DBA Data[Home] [Help]

APPS.HR_CONTRACT_API dependencies on HR_LOOKUPS

Line 1273: from hr_lookups hrl

1269: (p_lookup_code in varchar2,
1270: p_lookup_type in varchar2) return varchar2 is
1271:
1272: cursor csr_meaning is select meaning
1273: from hr_lookups hrl
1274: where p_lookup_code = hrl.lookup_code
1275: and p_lookup_type = hrl.lookup_type
1276: and hrl.application_id = 800;
1277:

Line 1280: l_meaning hr_lookups.meaning%type;

1276: and hrl.application_id = 800;
1277:
1278: -- set up the variables
1279:
1280: l_meaning hr_lookups.meaning%type;
1281:
1282: begin
1283:
1284: open csr_meaning;