DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_SALARY dependencies on HRIFV_SAL_PRO

Line 86: from HRIFV_SAL_PRO

82: RETURN NUMBER IS
83:
84: cursor cur_get_ann_sal(cp_effective_date date,cp_assignment_id number) IS
85: select annual_salary
86: from HRIFV_SAL_PRO
87: where assignment_id = cp_assignment_id
88: and cp_effective_date between effective_from_date and effective_to_date_nn;
89:
90: l_annual_salary number :=0;