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 1194: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;

1190: x_base_min_unit NUMBER;
1191: x_precision INTEGER;
1192: x_base_precision INTEGER;
1193: x_result_fld NUMBER;
1194: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
1195: BEGIN
1196: if (x_object_type in ('H','B') ) then
1197:
1198: if x_base_cur_result then

Line 6173: hr_all_organization_units haou,

6169: x_chart_of_accounts_id,
6170: x_operating_unit_id,
6171: x_legal_entity_id
6172: FROM hr_organization_information hoi,
6173: hr_all_organization_units haou,
6174: mtl_parameters mp,
6175: gl_sets_of_books gsob
6176: WHERE mp.organization_id = p_inv_org_id
6177: AND mp.organization_id = haou.organization_id