APPS.PAY_IN_UTILS dependencies on HR_LOOKUPS

Line 2497: l_relation hr_lookups.meaning%TYPE;

2493: AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date
2494: AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
2495:
2496:
2497: l_relation hr_lookups.meaning%TYPE;
2498: l_emp_person_id NUMBER;
2499:
2500:
2501: BEGIN

Line 2665: FROM hr_lookups hrl

2661: IS
2662: CURSOR csr_ltc_block
2663: IS
2664: SELECT lookup_code
2665: FROM hr_lookups hrl
2666: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2667: AND p_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2668: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2669:

Line 2670: l_ltc_block hr_lookups.lookup_code%TYPE;

2666: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2667: AND p_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2668: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2669:
2670: l_ltc_block hr_lookups.lookup_code%TYPE;
2671:
2672: BEGIN
2673: OPEN csr_ltc_block;
2674: FETCH csr_ltc_block INTO l_ltc_block;

Line 2699: FROM hr_lookups hrl

2695: IS
2696: CURSOR csr_ltc_block(l_effective_date DATE)
2697: IS
2698: SELECT lookup_code
2699: FROM hr_lookups hrl
2700: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2701: AND l_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2702: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2703:

Line 2704: l_ltc_block hr_lookups.lookup_code%TYPE;

2700: WHERE HRL.lookup_type = 'IN_LTC_BLOCK'
2701: AND l_effective_date BETWEEN TO_DATE(SUBSTR(HRL.MEANING,1,11),'DD-MM-YYYY')
2702: AND TO_DATE(SUBSTR(HRL.MEANING,15,11),'DD-MM-YYYY');
2703:
2704: l_ltc_block hr_lookups.lookup_code%TYPE;
2705: l_effective_date DATE;
2706:
2707: BEGIN
2708: l_effective_date := add_months(p_effective_date,-48);