APPS.PAY_GARN_LIMIT_RULES_PKG dependencies on PAY_STATE_RULES

Line 20: l_state_name pay_state_rules.name%TYPE;

16: x_garn_category VARCHAR2,
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:

Line 27: FROM pay_state_rules

23: l_meaning hr_lookups.meaning%TYPE;
24:
25: CURSOR state_c IS
26: SELECT name
27: FROM pay_state_rules
28: WHERE substr(jurisdiction_code, 1, 2) = x_state_code;
29:
30: CURSOR lookup_c IS
31: SELECT meaning