1368: cursor csr_amount_lookup ( p_lookup_code in varchar2
1369: ,p_effective_date in date
1370: ) is
1371: select null 1372: from hr_lookups 1373: where lookup_type = 'PAY_METHOD_AMOUNT_TYPE'
1374: and lookup_code = p_lookup_code
1375: and enabled_flag = 'Y'
1376: and p_effective_date between nvl(start_date_active, p_effective_date)