44: p_line IN VARCHAR2
45: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
46: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
47: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
48: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
45: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
46: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
47: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
48: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
46: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
47: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
48: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
47: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
48: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
48: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
49: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
50: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
58: );
51: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
58: );
59:
52: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
58: );
59:
60: PROCEDURE end_date_child (
53: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
54: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
55: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
56: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
57: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
58: );
59:
60: PROCEDURE end_date_child (
61: p_range_table_id IN NUMBER