DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_NOA_FAMILIES

Line 84: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families

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

Line 1215: (select NOA_FAMILY_CODE from ghr_noa_families

1211: cursor get_sal_chg_fam (cnoacode varchar2) is
1212: select NOA_FAMILY_CODE
1213: from ghr_families
1214: where NOA_FAMILY_CODE in
1215: (select NOA_FAMILY_CODE from ghr_noa_families
1216: where nature_of_action_id in
1217: (select nature_of_action_id
1218: from ghr_nature_of_actions
1219: where code = cnoacode)