APPS.PAY_GARN_EXEMPTION_RULES_PKG dependencies on HR_LOOKUPS

Line 25: l_lookup_type hr_lookups.lookup_type%TYPE;

21: x_d_calc_rule IN OUT VARCHAR2,
22: x_d_dependents_calc_rule IN OUT VARCHAR2
23: ) IS
24: l_state_name pay_state_rules.name%TYPE;
25: l_lookup_type hr_lookups.lookup_type%TYPE;
26: l_lookup_code hr_lookups.lookup_code%TYPE;
27: l_meaning hr_lookups.meaning%TYPE;
28:
29: CURSOR state_c IS

Line 26: l_lookup_code hr_lookups.lookup_code%TYPE;

22: x_d_dependents_calc_rule IN OUT VARCHAR2
23: ) IS
24: l_state_name pay_state_rules.name%TYPE;
25: l_lookup_type hr_lookups.lookup_type%TYPE;
26: l_lookup_code hr_lookups.lookup_code%TYPE;
27: l_meaning hr_lookups.meaning%TYPE;
28:
29: CURSOR state_c IS
30: SELECT name

Line 27: l_meaning hr_lookups.meaning%TYPE;

23: ) IS
24: l_state_name pay_state_rules.name%TYPE;
25: l_lookup_type hr_lookups.lookup_type%TYPE;
26: l_lookup_code hr_lookups.lookup_code%TYPE;
27: l_meaning hr_lookups.meaning%TYPE;
28:
29: CURSOR state_c IS
30: SELECT name
31: FROM pay_state_rules

Line 36: FROM hr_lookups

32: WHERE substr(jurisdiction_code, 1, 2) = x_state_code;
33:
34: CURSOR lookup_c IS
35: SELECT meaning
36: FROM hr_lookups
37: WHERE lookup_type = l_lookup_type
38: AND lookup_code = l_lookup_code;
39:
40: BEGIN