[Home] [Help]
797: WHERE payroll_id = cp_payroll_id;
798:
799: CURSOR c_get_consolidation_set_name (cp_consolidation_set_id in NUMBER) IS
800: SELECT consolidation_set_name
801: FROM pay_consolidation_sets
802: WHERE consolidation_set_id=cp_consolidation_set_id;
803:
804: /***********************************************************
805: CURSOR to get effective date for a payroll action id