APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_PAY_BASES_V

Line 202: FROM hr_h2pi_pay_bases_v

198: WHERE client_id = p_from_client_id;
199:
200: CURSOR csr_pay_pay_bases IS
201: SELECT pay_basis_id
202: FROM hr_h2pi_pay_bases_v
203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id

Line 207: FROM hr_h2pi_pay_bases_v pay

203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id
207: FROM hr_h2pi_pay_bases_v pay
208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
209: AND pay.pay_basis_id = p_pay_basis_id
210: AND NOT EXISTS (SELECT 'X'
211: FROM hr_h2pi_id_mapping him,

Line 220: FROM hr_h2pi_pay_bases_v pay

216: AND him.to_business_group_id = pay.business_group_id);
217:
218: CURSOR csr_payroll_data_added(p_pay_basis_id NUMBER) IS
219: SELECT pay_basis_id
220: FROM hr_h2pi_pay_bases_v pay
221: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
222: AND pay.pay_basis_id = p_pay_basis_id
223: AND NOT EXISTS (SELECT 'X'
224: FROM hr_h2pi_id_mapping him

Line 230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;

226: AND him.table_name = 'PER_PAY_BASES'
227: AND him.to_business_group_id =
228: hr_h2pi_upload.g_to_business_group_id);
229:
230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;
231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;
232: l_counter BINARY_INTEGER ;
233: l_pay_basis_id hr_h2pi_pay_bases.pay_basis_id%TYPE;
234: l_record_ok BOOLEAN;

Line 261: FROM hr_h2pi_pay_bases_v

257: hr_utility.set_location(l_proc, 40);
258: BEGIN
259: SELECT *
260: INTO l_ed_rec
261: FROM hr_h2pi_pay_bases_v
262: WHERE pay_basis_id = l_pay_basis_to_id;
263:
264: l_counter := l_counter + 1 ;
265: pay_bases_tab(l_counter) := l_pay_basis_to_id;