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
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
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
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