DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 296: ,hr_all_organization_units b

292: CURSOR check_source (p_bus_grp_id NUMBER,
293: p_entry_value VARCHAR2) is
294: select 'S'
295: from hr_organization_information d
296: ,hr_all_organization_units b
297: where to_number(d.org_information20) = to_number(p_entry_value)
298: and b.business_group_id = p_bus_grp_id
299: and b.organization_id = d.organization_id
300: and d.org_information_context = 'HK_MPF_SCHEMES';