DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_FAMILIES

Line 82: FROM ghr_families

78: for update of user_table_id nowait;
79:
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

Line 1213: from ghr_families

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