APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_PAYMENT_METHODS_V

Line 2681: FROM hr_h2pi_payment_methods_v ppm

2677:
2678: CURSOR csr_ed_payment_method (p_ppm_id NUMBER,
2679: p_esd DATE) IS
2680: SELECT *
2681: FROM hr_h2pi_payment_methods_v ppm
2682: WHERE ppm.personal_payment_method_id = p_ppm_id
2683: AND p_esd BETWEEN ppm.effective_start_date
2684: AND ppm.effective_end_date;
2685:

Line 2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;

2696:
2697: l_proc VARCHAR2(72) := g_package||'upload_payment_method';
2698:
2699: v_ud_ppm hr_h2pi_payment_methods%ROWTYPE;
2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;
2701:
2702: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2703: l_personal_pay_method_id
2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;