DBA Data[Home] [Help]

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_BALANCE_PKG

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

888: CURSOR c_balance_values(p_employee_number VARCHAR2
889: ,p_bus_grp_id NUMBER
890: ,p_max_asg_id NUMBER)
891: IS
892: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
893: , paa.assignment_action_id)) amount
894: , pbt.balance_name description
895: FROM per_assignments_f paf
896: ,per_people_f ppf

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

967: CURSOR c_gratuity_elig_sal(p_employee_number VARCHAR2
968: ,p_bus_grp_id NUMBER
969: ,p_max_asg_id NUMBER)
970: IS
971: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
972: , paa.assignment_action_id)) amount
973: , pbt.balance_name description
974: FROM per_assignments_f paf
975: ,per_people_f ppf