DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 3156: hr_organization_information hoi

3152: INTO l_operatingUnit
3153: FROM hr_organization_units hou,
3154: wip_parameters wp,
3155: mtl_parameters mp,
3156: hr_organization_information hoi
3157: WHERE hou.organization_id = hoi.organization_id
3158: and ( hoi.org_information_context || '') = 'Accounting Information'
3159: and wp.organization_id = mp.organization_id
3160: and wp.organization_id = hou.organization_id

Line 3526: FROM hr_organization_information

3522: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
3523:
3524: -- Set Additional OU context when Flow is from AFAS as required by Projects in Bug 12674069.
3525: SELECT TO_NUMBER(org_information3) into l_ou_context
3526: FROM hr_organization_information
3527: WHERE org_information_context = 'Accounting Information'
3528: AND organization_id = wjsi_row.organization_id;
3529:
3530: MO_GLOBAL.set_policy_context(p_access_mode => 'S',p_org_id => l_ou_context);