DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 477: from hr_organization_information hoi,

473: and effective date */
474: CURSOR c_all_gres(cp_bg_id number,
475: cp_eff_date date) IS
476: select hou.organization_id
477: from hr_organization_information hoi,
478: hr_all_organization_units hou
479: where hou.business_group_id = cp_bg_id
480: AND hou.organization_id = hoi.organization_id
481: AND hou.date_from <= cp_eff_date