DBA Data[Home] [Help]

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_BALANCE_PKG

Line 989: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id

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

Line 1068: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id

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