APPS.HRI_DBI_WMV_BUDGET dependencies on HR_PTL_SUMMARY_DATA

Line 119: FROM hr_ptl_summary_data psum

115: bis_collection_utilities.log('*HRI_DBI_WMV_BUDGET.FULL_REFRESH*',1);
116: bis_collection_utilities.log('********************************',1);
117:
118: DELETE
119: FROM hr_ptl_summary_data psum
120: WHERE psum.sum_information_category = 'HRI_DBI_WMV_BUDGET'
121: AND psum.summary_context_type = 'SUPERVISOR';
122: COMMIT;
123: --

Line 153: INSERT INTO hr_ptl_summary_data

149: EXIT WHEN c_events%NOTFOUND;
150:
151: l_location_id := null;
152:
153: INSERT INTO hr_ptl_summary_data
154: ( summary_data_id
155: ,summary_context_type
156: ,summary_context_id
157: ,effective_date

Line 165: VALUES ( hr_ptl_summary_data_s.NEXTVAL

161: ,sum_information_category
162: ,sum_information1
163: ,sum_information2
164: ,effective_end_date)
165: VALUES ( hr_ptl_summary_data_s.NEXTVAL
166: ,g_con_context_type
167: ,l_supervisor_id
168: ,l_effective_date
169: ,fnd_global.user_id