DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on HR_LOOKUPS

Line 1372: from hr_lookups

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)