APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_COST_ALLOCATIONS_V

Line 3080: FROM hr_h2pi_cost_allocations_v hca

3076:
3077: CURSOR csr_ed_cost_allocation (p_cost_allocation_id NUMBER,
3078: p_esd DATE) IS
3079: SELECT *
3080: FROM hr_h2pi_cost_allocations_v hca
3081: WHERE hca.cost_allocation_id = p_cost_allocation_id
3082: AND p_esd BETWEEN hca.effective_start_date
3083: AND hca.effective_end_date;
3084:

Line 3097: v_ed_hca hr_h2pi_cost_allocations_v%ROWTYPE;

3093: l_encoded_message VARCHAR2(200);
3094: l_proc VARCHAR2(72) := g_package||'upload_cost_allocation';
3095:
3096: v_ud_hca hr_h2pi_cost_allocations%ROWTYPE;
3097: v_ed_hca hr_h2pi_cost_allocations_v%ROWTYPE;
3098:
3099: l_assignment_id pay_cost_allocations_f.assignment_id%TYPE;
3100: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
3101: l_combination_name VARCHAR2(240);