APPS.PAY_IN_UTILS dependencies on HR_LOOKUPS

Line 2482: l_relation hr_lookups.meaning%TYPE;

2478: AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date
2479: AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
2480:
2481:
2482: l_relation hr_lookups.meaning%TYPE;
2483: l_emp_person_id NUMBER;
2484:
2485:
2486: BEGIN

Line 2650: FROM hr_lookups hrl

2646: IS
2647: CURSOR csr_ltc_block
2648: IS
2649: SELECT lookup_code
2650: FROM hr_lookups hrl
2651: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2652: AND p_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2653: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2654:

Line 2655: l_ltc_block hr_lookups.lookup_code%TYPE;

2651: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2652: AND p_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2653: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2654:
2655: l_ltc_block hr_lookups.lookup_code%TYPE;
2656:
2657: BEGIN
2658: OPEN csr_ltc_block;
2659: FETCH csr_ltc_block INTO l_ltc_block;

Line 2684: FROM hr_lookups hrl

2680: IS
2681: CURSOR csr_ltc_block(l_effective_date DATE)
2682: IS
2683: SELECT lookup_code
2684: FROM hr_lookups hrl
2685: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2686: AND l_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2687: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2688:

Line 2689: l_ltc_block hr_lookups.lookup_code%TYPE;

2685: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2686: AND l_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2687: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2688:
2689: l_ltc_block hr_lookups.lookup_code%TYPE;
2690: l_effective_date DATE;
2691:
2692: BEGIN
2693: l_effective_date := add_months(p_effective_date,-48);