402: l_source_text_iv number(2) := 0;
403: l_source_text_iv_val VARCHAR2(30);
404: l_source_text2_iv number(2) := 0;
405: l_source_text2_iv_val VARCHAR2(30);
406: l_leg_code pay_legislation_rules.legislation_code%TYPE;
407: l_seq_number NUMBER(2);
408: l_no_input_values NUMBER(10);
409:
410: l_message VARCHAR2(255);
437:
438: CURSOR csr_rule1 (p_leg_code IN VARCHAR2)
439: IS
440: SELECT 1, rule_mode
441: FROM pay_legislation_rules
442: WHERE rule_type ='SOURCE_IV'
443: AND legislation_code = p_leg_code;
444:
445: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)
444:
445: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)
446: IS
447: SELECT 1, rule_mode
448: FROM pay_legislation_rules
449: WHERE rule_type ='SOURCE_TEXT_IV'
450: AND legislation_code = p_leg_code;
451:
452: CURSOR csr_rule3 (p_leg_code IN VARCHAR2)