APPS.GHR_BEN_VALIDATION dependencies on GHR_NOA_FAMILIES

Line 1235: l_noa_family_code ghr_noa_families.noa_family_code%type;

1231: l_asg_ei_data per_assignment_extra_info%rowtype;
1232: l_annuitant_indicator per_assignment_extra_info.aei_information5%type;
1233: l_session ghr_history_api.g_session_var_type;
1234: l_noa_id number;
1235: l_noa_family_code ghr_noa_families.noa_family_code%type;
1236:
1237: -- Bug 4760226
1238: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
1239: c_effective_date ghr_nature_of_actions.date_from%type) IS

Line 1241: FROM ghr_noa_families

1237: -- Bug 4760226
1238: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
1239: c_effective_date ghr_nature_of_actions.date_from%type) IS
1240: SELECT noa_family_code
1241: FROM ghr_noa_families
1242: WHERE nature_of_action_id = c_noa_id
1243: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
1244: AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));
1245: