APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_ORG_PAYMENT_METHODS_V

Line 677: FROM hr_h2pi_org_payment_methods_v

673: WHERE client_id = p_from_client_id;
674:
675: CURSOR csr_pay_org_payment_method IS
676: SELECT org_payment_method_id
677: FROM hr_h2pi_org_payment_methods_v
678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id

Line 682: FROM hr_h2pi_org_payment_methods_v ele

678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id
682: FROM hr_h2pi_org_payment_methods_v ele
683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
684: AND ele.org_payment_method_id = p_org_payment_method_id
685: AND NOT EXISTS (SELECT 'X'
686: FROM hr_h2pi_id_mapping him,

Line 695: FROM hr_h2pi_org_payment_methods_v ele

691: AND him.to_business_group_id = ele.business_group_id);
692:
693: CURSOR csr_payroll_data_added(p_org_payment_method_id NUMBER) IS
694: SELECT org_payment_method_id
695: FROM hr_h2pi_org_payment_methods_v ele
696: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
697: AND ele.org_payment_method_id = p_org_payment_method_id
698: AND NOT EXISTS (SELECT 'X'
699: FROM hr_h2pi_id_mapping him

Line 705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;

701: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
702: AND him.to_business_group_id =
703: hr_h2pi_upload.g_to_business_group_id);
704:
705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;
706: l_org_payment_method_to_id
707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;
708: l_counter BINARY_INTEGER ;
709: l_org_payment_method_id

Line 738: FROM hr_h2pi_org_payment_methods_v

734: hr_utility.set_location(l_proc, 40);
735: BEGIN
736: SELECT *
737: INTO l_ed_rec
738: FROM hr_h2pi_org_payment_methods_v
739: WHERE org_payment_method_id = l_org_payment_method_to_id
740: AND effective_start_date = v_ud_rec.effective_start_date
741: AND effective_end_date = v_ud_rec.effective_end_date;
742: