eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_DEDUCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 97: -- 1.2 20-MAR-03 vinaraya Changed the tables PER_ALL_ASSIGNMENTS_F --

93: -- Rev# Date Userid Description --
94: --------------------------------------------------------------------------
95: -- 1.0 18-FEB-03 vinaraya Created this function --
96: -- 1.1 19-MAR-03 vinaraya Changed the indentation --
97: -- 1.2 20-MAR-03 vinaraya Changed the tables PER_ALL_ASSIGNMENTS_F --
98: -- to PER_ALL_ASSIGNMENTS and HR_SOFT_CODIN --
99: -- G_KEYFLEX_KFV to HR_SOFT_CODING_KEYFLEX --
100: -- in csr_tax for performance reasons. --
101: -- 1.3 20-MAR-03 vinaraya Changed the p_special_payment_type_id --

Line 1150: FROM per_all_assignments_f

1146: --
1147: CURSOR csr_years_of_service(c_effective_date DATE, c_assignment_id NUMBER)
1148: IS
1149: SELECT fnd_number.canonical_to_number(round(months_between(c_effective_date,min(effective_start_date))/12,2)) mths_of_service
1150: FROM per_all_assignments_f
1151: WHERE assignment_id = c_assignment_id; --
1152: -- Cursor to find number of column instances of user table
1153: --
1154: CURSOR csr_count_inst(c_table_name VARCHAR2