DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_NOA_FAMILIES

Line 1084: select noa_family_code from ghr_noa_families

1080: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
1081: --
1082: -- Bug#3941541 Added parameter p_effective_date.
1083: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1084: select noa_family_code from ghr_noa_families
1085: where nature_of_action_id in
1086: ( select nature_of_action_id from ghr_nature_of_actions
1087: where code = p_noa_code )
1088: and noa_family_code in