APPS.PAY_GARN_LIMIT_RULES_PKG dependencies on HR_LOOKUPS

Line 21: l_lookup_type hr_lookups.lookup_type%TYPE;

17: x_state_name IN OUT VARCHAR2,
18: x_garn_category_name IN OUT VARCHAR2
19: ) IS
20: l_state_name pay_state_rules.name%TYPE;
21: l_lookup_type hr_lookups.lookup_type%TYPE;
22: l_lookup_code hr_lookups.lookup_code%TYPE;
23: l_meaning hr_lookups.meaning%TYPE;
24:
25: CURSOR state_c IS

Line 22: l_lookup_code hr_lookups.lookup_code%TYPE;

18: x_garn_category_name IN OUT VARCHAR2
19: ) IS
20: l_state_name pay_state_rules.name%TYPE;
21: l_lookup_type hr_lookups.lookup_type%TYPE;
22: l_lookup_code hr_lookups.lookup_code%TYPE;
23: l_meaning hr_lookups.meaning%TYPE;
24:
25: CURSOR state_c IS
26: SELECT name

Line 23: l_meaning hr_lookups.meaning%TYPE;

19: ) IS
20: l_state_name pay_state_rules.name%TYPE;
21: l_lookup_type hr_lookups.lookup_type%TYPE;
22: l_lookup_code hr_lookups.lookup_code%TYPE;
23: l_meaning hr_lookups.meaning%TYPE;
24:
25: CURSOR state_c IS
26: SELECT name
27: FROM pay_state_rules

Line 32: FROM hr_lookups

28: WHERE substr(jurisdiction_code, 1, 2) = x_state_code;
29:
30: CURSOR lookup_c IS
31: SELECT meaning
32: FROM hr_lookups
33: WHERE lookup_type = l_lookup_type
34: AND lookup_code = l_lookup_code;
35:
36: BEGIN