APPS.GHR_BEN_VALIDATION dependencies on GHR_NOA_FAMILIES

Line 808: l_noa_family_code ghr_noa_families.noa_family_code%type;

804: l_asg_ei_data per_assignment_extra_info%rowtype;
805: l_annuitant_indicator per_assignment_extra_info.aei_information5%type;
806: l_session ghr_history_api.g_session_var_type;
807: l_noa_id number;
808: l_noa_family_code ghr_noa_families.noa_family_code%type;
809:
810: -- Bug 4760226
811: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
812: c_effective_date ghr_nature_of_actions.date_from%type) IS

Line 814: FROM ghr_noa_families

810: -- Bug 4760226
811: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
812: c_effective_date ghr_nature_of_actions.date_from%type) IS
813: SELECT noa_family_code
814: FROM ghr_noa_families
815: WHERE nature_of_action_id = c_noa_id
816: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
817: AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));
818: