DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 470: from hr_organization_information hoi,

466: and effective date */
467: CURSOR c_all_pres(cp_bg_id number,
468: cp_eff_date date) IS
469: select hou.organization_id
470: from hr_organization_information hoi,
471: hr_all_organization_units hou
472: where hou.business_group_id = cp_bg_id
473: AND hou.organization_id = hoi.organization_id
474: AND hou.date_from <= cp_eff_date