DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on HR_ALL_ORGANIZATION_UNITS

Line 245: org_name hr_all_organization_units.name%TYPE;

241: /** **/
242: /** tpoon 9/27/2002 **/
243: /** Changed org_name to use %TYPE **/
244: -- org_name VARCHAR2(60);
245: org_name hr_all_organization_units.name%TYPE;
246:
247: sob_id NUMBER;
248: begin
249: x_progress := 10;

Line 1199: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;

1195: x_base_min_unit NUMBER;
1196: x_precision INTEGER;
1197: x_base_precision INTEGER;
1198: x_result_fld NUMBER;
1199: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
1200:
1201: --bug 12723347
1202: l_rel_amt_same_curr NUMBER;
1203: l_rel_amt_diff_curr NUMBER;

Line 6381: hr_all_organization_units haou,

6377: x_chart_of_accounts_id,
6378: x_operating_unit_id,
6379: x_legal_entity_id
6380: FROM hr_organization_information hoi,
6381: hr_all_organization_units haou,
6382: mtl_parameters mp,
6383: gl_sets_of_books gsob
6384: WHERE mp.organization_id = p_inv_org_id
6385: AND mp.organization_id = haou.organization_id