APPS.PAY_IPD_BUS dependencies on HR_LOOKUPS

Line 314: FROM hr_lookups

310: ) IS
311: -- select wehre info_source exists
312: CURSOR csr_info_source IS
313: SELECT NULL
314: FROM hr_lookups
315: WHERE lookup_code = p_info_source
316: AND lookup_type = 'IE_PAYE_INFO_SOURCE'
317: AND enabled_flag = 'Y'
318: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 485: FROM hr_lookups

481: ) IS
482: -- select wehre tax_basis exists
483: CURSOR csr_tax_basis IS
484: SELECT NULL
485: FROM hr_lookups
486: WHERE lookup_code = p_tax_basis
487: AND lookup_type = 'IE_PAYE_TAX_BASIS'
488: AND enabled_flag = 'Y'
489: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 539: FROM hr_lookups

535: ) IS
536: -- select wehre tax_assess_basis exists
537: CURSOR csr_tax_assess_basis IS
538: SELECT NULL
539: FROM hr_lookups
540: WHERE lookup_code = p_tax_assess_basis
541: AND lookup_type = 'IE_PAYE_ASSESS_BASIS'
542: AND enabled_flag = 'Y'
543: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);