458: /* Get the jurisdiction_code for the specified state code. */
459:
460: cursor csr_jurisdiction_code is
461: select SR.jurisdiction_code
462: from pay_state_rules SR
463: where SR.state_code = p_state;
464:
465: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
466:
461: select SR.jurisdiction_code
462: from pay_state_rules SR
463: where SR.state_code = p_state;
464:
465: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
466:
467: begin
468:
469: open csr_jurisdiction_code;