DBA Data[Home] [Help]

APPS.PO_SHARED_PROC_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 257: hr_organization_information hoi,

253: --SQL WHY: To define the Destination Account flexfield structure.
254: SELECT gsb.chart_of_accounts_id
255: INTO l_coa_id
256: FROM gl_sets_of_books gsb,
257: hr_organization_information hoi,
258: mtl_parameters mp
259: WHERE mp.organization_id = p_inv_org_id
260: AND mp.organization_id = hoi.organization_id
261: AND hoi.org_information_context = 'Accounting Information'

Line 324: hr_organization_information hoi,

320: --SQL WHY: To define the Destination Account flexfield structure.
321: SELECT TO_NUMBER(hoi.org_information3), gsb.chart_of_accounts_id
322: INTO x_ou_id, x_coa_id
323: FROM gl_sets_of_books gsb,
324: hr_organization_information hoi,
325: mtl_parameters mp
326: WHERE mp.organization_id = p_inv_org_id
327: AND mp.organization_id = hoi.organization_id
328: AND hoi.org_information_context = 'Accounting Information'

Line 1340: FROM hr_organization_information hoi

1336: -- MC INVCONV END
1337: INTO l_end_ou_id,
1338: l_ship_to_org_sob_id
1339: --l_ship_to_org_opm_flag
1340: FROM hr_organization_information hoi
1341: --mtl_parameters mp
1342: WHERE
1343: -- MC INVCONV START
1344: hoi.organization_id = p_ship_to_org_id