DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on HR_LOOKUPS

Line 1447: from hr_lookups

1443: cursor csr_amount_lookup ( p_lookup_code in varchar2
1444: ,p_effective_date in date
1445: ) is
1446: select null
1447: from hr_lookups
1448: where lookup_type = 'PAY_METHOD_AMOUNT_TYPE'
1449: and lookup_code = p_lookup_code
1450: and enabled_flag = 'Y'
1451: and p_effective_date between nvl(start_date_active, p_effective_date)