APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_PAYROLLS_V

Line 357: FROM hr_h2pi_payrolls_v

353: WHERE client_id = p_from_client_id;
354:
355: CURSOR csr_pay_payrolls IS
356: SELECT payroll_id
357: FROM hr_h2pi_payrolls_v
358: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
359:
360: CURSOR csr_hr_data_removed (p_payroll_id NUMBER) IS
361: SELECT payroll_id

Line 362: FROM hr_h2pi_payrolls_v pay

358: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
359:
360: CURSOR csr_hr_data_removed (p_payroll_id NUMBER) IS
361: SELECT payroll_id
362: FROM hr_h2pi_payrolls_v pay
363: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
364: AND pay.payroll_id = p_payroll_id
365: AND NOT EXISTS (SELECT 'X'
366: FROM hr_h2pi_id_mapping him,

Line 375: FROM hr_h2pi_payrolls_v pay

371: AND him.to_business_group_id = pay.business_group_id);
372:
373: CURSOR csr_payroll_data_added(p_payroll_id NUMBER) IS
374: SELECT payroll_id
375: FROM hr_h2pi_payrolls_v pay
376: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
377: AND pay.payroll_id = p_payroll_id
378: AND NOT EXISTS (SELECT 'X'
379: FROM hr_h2pi_id_mapping him

Line 385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;

381: AND him.table_name = 'PAY_ALL_PAYROLLS_F'
382: AND him.to_business_group_id =
383: hr_h2pi_upload.g_to_business_group_id);
384:
385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;
386: l_payroll_to_id pay_all_payrolls_f.payroll_id%TYPe;
387: l_counter BINARY_INTEGER ;
388: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
389: l_record_ok BOOLEAN;

Line 416: FROM hr_h2pi_payrolls_v

412: BEGIN
413: hr_utility.set_location(l_proc, 40);
414: SELECT *
415: INTO l_ed_rec
416: FROM hr_h2pi_payrolls_v
417: WHERE payroll_id = l_payroll_to_id
418: AND effective_start_date = v_ud_rec.effective_start_date
419: AND effective_end_date = v_ud_rec.effective_end_date;
420: