DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on HR_GENERAL

Line 2332: AND decode(hr_general.get_xbg_profile,'Y',per.business_group_id , hr_general.get_business_group_id) = per.business_group_id;

2328: AND par.effective_date >= add_months(p_end_date,-24)
2329: AND par.effective_date <= add_months(p_end_date,6)
2330: AND exclude_agency(NVL(par.agency_code,par.from_agency_code)) <> 'TRUE'
2331: AND exclude_noac(par.first_noa_code,par.second_noa_code,par.noa_family_code) <> 'TRUE'
2332: AND decode(hr_general.get_xbg_profile,'Y',per.business_group_id , hr_general.get_business_group_id) = per.business_group_id;
2333: --
2334: -- Cross Business Group if set to Yes, the pick all the records else pick BG related records.
2335: --
2336: -- Note: