DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 366: ,hr_all_organization_units b

362: CURSOR check_source (p_bus_grp_id NUMBER,
363: p_entry_value VARCHAR2) is
364: select 'S'
365: from hr_organization_information d
366: ,hr_all_organization_units b
367: where to_number(d.org_information20) = to_number(p_entry_value)
368: and b.business_group_id = p_bus_grp_id
369: and b.organization_id = d.organization_id
370: and d.org_information_context = 'HK_MPF_SCHEMES';