DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 2456: FROM hr_organization_information org_info,

2452: INSERT INTO po_session_gt(key, num1, num2)
2453: SELECT p_key,
2454: p_index_tbl(i),
2455: TO_NUMBER(org_info.org_information3)
2456: FROM hr_organization_information org_info,
2457: mtl_parameters param
2458: WHERE param.organization_id = p_ship_to_org_id_tbl(i)
2459: AND param.organization_id = org_info.organization_id
2460: AND org_info.org_information_context = 'Accounting Information';

Line 3146: hr_organization_information org_info,

3142: SELECT p_key,
3143: p_index_tbl(i),
3144: sob.chart_of_accounts_id
3145: FROM gl_sets_of_books sob,
3146: hr_organization_information org_info,
3147: mtl_parameters param
3148: WHERE p_txn_flow_header_id_tbl(i) IS NOT NULL
3149: AND p_dest_charge_account_id_tbl(i) IS NULL
3150: AND param.organization_id = p_dest_org_id_tbl(i)