DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_FAMILIES

Line 183: from ghr_families

179:
180: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]
181: cursor get_sal_chg_fam is
182: select NOA_FAMILY_CODE
183: from ghr_families
184: where NOA_FAMILY_CODE in
185: (select NOA_FAMILY_CODE from ghr_noa_families
186: where nature_of_action_id =
187: (select nature_of_action_id

Line 5029: from ghr_families

5025:
5026: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]
5027: /*cursor get_sal_chg_fam is
5028: select NOA_FAMILY_CODE
5029: from ghr_families
5030: where NOA_FAMILY_CODE in
5031: (select NOA_FAMILY_CODE from ghr_noa_families
5032: where nature_of_action_id =
5033: (select nature_of_action_id

Line 5260: from ghr_families

5256: AND g_effective_date between effective_start_date and effective_end_date;
5257: --7577249
5258: cursor get_sal_chg_fam is
5259: select NOA_FAMILY_CODE
5260: from ghr_families
5261: where NOA_FAMILY_CODE in
5262: (select NOA_FAMILY_CODE from ghr_noa_families
5263: where nature_of_action_id =
5264: (select nature_of_action_id

Line 7081: from ghr_families

7077:
7078: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]
7079: cursor get_sal_chg_fam is
7080: select NOA_FAMILY_CODE
7081: from ghr_families
7082: where NOA_FAMILY_CODE in
7083: (select NOA_FAMILY_CODE from ghr_noa_families
7084: where nature_of_action_id =
7085: (select nature_of_action_id