543: /* Get the jurisdiction_code for the specified state code. */
544:
545: cursor csr_jurisdiction_code is
546: select SR.jurisdiction_code
547: from pay_state_rules SR
548: where SR.state_code = p_state;
549:
550: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
551:
546: select SR.jurisdiction_code
547: from pay_state_rules SR
548: where SR.state_code = p_state;
549:
550: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
551:
552: begin
553:
554: open csr_jurisdiction_code;