[Home] [Help]
2133: --
2134: cursor c_get_ncr(p_pto_input_value_id number) is
2135: select net_calculation_rule_id,
2136: object_version_number
2137: from pay_net_calculation_rules
2138: where accrual_plan_id = p_accrual_plan_id
2139: and input_value_id = p_pto_input_value_id;
2140:
2141: cursor c_class_id(p_classification_name varchar2,
3092:
3093: cursor c_get_ncr(p_accrual_plan_id number) is
3094: select net_calculation_rule_id,
3095: object_version_number
3096: from pay_net_calculation_rules
3097: where accrual_plan_id = p_accrual_plan_id;
3098:
3099: l_proc varchar2(72);
3100: l_effective_start_date date;