APPS.PAY_SID_BUS dependencies on HR_LOOKUPS

Line 308: FROM hr_lookups

304: ) IS
305: -- select wehre director_flag exists
306: CURSOR csr_director_flag IS
307: SELECT NULL
308: FROM hr_lookups
309: WHERE lookup_code = p_director_flag
310: AND lookup_type = 'YES_NO'
311: AND enabled_flag = 'Y'
312: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 362: FROM hr_lookups

358: ) IS
359: -- select wehre contribution_class exists
360: CURSOR csr_contribution_class IS
361: SELECT NULL
362: FROM hr_lookups
363: WHERE lookup_code = p_contribution_class
364: AND lookup_type = 'IE_PRSI_CONT_CLASS'
365: AND enabled_flag = 'Y'
366: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 416: FROM hr_lookups

412: ) IS
413: -- select wehre overridden_subclass exists
414: CURSOR csr_overridden_subclass IS
415: SELECT NULL
416: FROM hr_lookups
417: WHERE lookup_code = p_overridden_subclass
418: AND lookup_type = 'IE_PRSI_CONT_SUBCLASS'
419: AND enabled_flag = 'Y'
420: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 469: FROM hr_lookups

465: ) IS
466: -- select wehre soc_ben_flag exists
467: CURSOR csr_soc_ben_flag IS
468: SELECT NULL
469: FROM hr_lookups
470: WHERE lookup_code = p_soc_ben_flag
471: AND lookup_type = 'YES_NO'
472: AND enabled_flag = 'Y'
473: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);

Line 791: FROM hr_lookups

787: ) IS
788: -- select wehre community_flag exists
789: CURSOR csr_community_flag IS
790: SELECT NULL
791: FROM hr_lookups
792: WHERE lookup_code = p_community_flag
793: AND lookup_type = 'YES_NO'
794: AND enabled_flag = 'Y'
795: AND p_effective_date BETWEEN nvl(start_date_active, p_effective_date) AND nvl(end_date_active, p_effective_Date);