DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_NOA_FAMILIES

Line 86: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families

82: CURSOR get_sal_chg_fam is
83: SELECT NOA_FAMILY_CODE
84: FROM ghr_families
85: WHERE NOA_FAMILY_CODE in
86: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families
87: WHERE nature_of_action_id in
88: (SELECT nature_of_action_id
89: FROM ghr_nature_of_actions
90: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )

Line 1239: (select NOA_FAMILY_CODE from ghr_noa_families

1235: cursor get_sal_chg_fam (cnoacode varchar2) is
1236: select NOA_FAMILY_CODE
1237: from ghr_families
1238: where NOA_FAMILY_CODE in
1239: (select NOA_FAMILY_CODE from ghr_noa_families
1240: where nature_of_action_id in
1241: (select nature_of_action_id
1242: from ghr_nature_of_actions
1243: where code = cnoacode)