DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_NOA_FAMILIES

Line 1140: select noa_family_code from ghr_noa_families

1136: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
1137: --
1138: -- Bug#3941541 Added parameter p_effective_date.
1139: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1140: select noa_family_code from ghr_noa_families
1141: where nature_of_action_id in
1142: ( select nature_of_action_id from ghr_nature_of_actions
1143: where code = p_noa_code )
1144: and noa_family_code in