APPS.GHR_EHRI_DYNRPT dependencies on PER_ASSIGNMENTS

Line 815: l_asg_id per_assignments_f.assignment_id%TYPE;

811: FROM ghr_pa_requests
812: WHERE pa_request_id=p_request_id
813: AND person_id=p_person_id;
814: --
815: l_asg_id per_assignments_f.assignment_id%TYPE;
816: l_asg_ei_data per_assignment_extra_info%rowtype;
817:
818: BEGIN
819: --

Line 2412: l_api_assignment_id per_assignments.assignment_id%TYPE;

2408: --
2409: l_proc VARCHAR2(72) := g_package||'populate_ghr_cpdf_temp';
2410: --
2411: l_info_type VARCHAR2(200) := NULL;
2412: l_api_assignment_id per_assignments.assignment_id%TYPE;
2413: --
2414: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2415: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2416: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;