DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on GHR_NOA_FAMILIES

Line 409: FROM ghr_noa_families nfa

405: -- Bug#5168568 Removed Information type GHR_US_PAR_ETHNICITY_RACE
406: -- Having this EIT in the list is skipping the printing of Military service, frozen service.
407: CURSOR c_rit IS
408: SELECT rit.information_type
409: FROM ghr_noa_families nfa
410: ,ghr_pa_request_info_types rit
411: WHERE rit.noa_family_code = nfa.noa_family_code
412: AND (nfa.nature_of_action_id = p_first_noa_id
413: OR nfa.nature_of_action_id = p_second_noa_id)

Line 1283: from ghr_noa_families nof,

1279: Cursor c_noa_family(p_noa_id in number,
1280: p_effective_date in date)
1281: is
1282: Select fam.noa_family_code
1283: from ghr_noa_families nof,
1284: ghr_families fam
1285: where nof.nature_of_action_id = p_noa_id
1286: and fam.noa_family_code = nof.noa_family_code
1287: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'