DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_FAMILIES

Line 84: FROM ghr_families

80: for update of user_table_id nowait;
81:
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

Line 1237: from ghr_families

1233: ---Fetch Noa_family_code ---800 (CHG_DATA_ELEMENT) , 894 (GHR_SAL_PAY_ADJ)
1234:
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