APPS.PAY_GARN_EXEMPTION_RULES_PKG dependencies on PAY_STATE_RULES

Line 24: l_state_name pay_state_rules.name%TYPE;

20: x_garn_category_name IN OUT VARCHAR2,
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:

Line 31: FROM pay_state_rules

27: l_meaning hr_lookups.meaning%TYPE;
28:
29: CURSOR state_c IS
30: SELECT name
31: FROM pay_state_rules
32: WHERE substr(jurisdiction_code, 1, 2) = x_state_code;
33:
34: CURSOR lookup_c IS
35: SELECT meaning