APPS.PQH_TCT_SHD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 409: l_business_group_id hr_all_organization_units.business_group_id%type;

405: --
406: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type := 0;
407: l_consolidated_table_route_id pqh_transaction_categories.consolidated_table_route_id%type;
408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;
409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --
411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;

Line 437: from hr_all_organization_units

433: --
434: --
435: /**
436: Cursor c4 is select business_group_id
437: from hr_all_organization_units
438: where name = p_business_group_alias ;
439: **/
440: --
441: BEGIN