985: CURSOR c_balance_values(p_employee_number VARCHAR2
986: ,p_bus_grp_id NUMBER
987: ,p_max_asg_id NUMBER)
988: IS
989: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
990: , paa.assignment_action_id)) amount
991: , pbt.balance_name description
992: FROM per_assignments_f paf
993: ,per_people_f ppf
1064: CURSOR c_gratuity_elig_sal(p_employee_number VARCHAR2
1065: ,p_bus_grp_id NUMBER
1066: ,p_max_asg_id NUMBER)
1067: IS
1068: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
1069: , paa.assignment_action_id)) amount
1070: , pbt.balance_name description
1071: FROM per_assignments_f paf
1072: ,per_people_f ppf