eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on HR_ORGANIZATION_UNITS

Line 1880: l_organization_name hr_organization_units.name%TYPE;

1876: l_stmt_num NUMBER;
1877:
1878: l_batch VARCHAR2(15); --Increased width for Bug#2218654
1879: -- UTF8 changes l_organization_name VARCHAR2(60);
1880: l_organization_name hr_organization_units.name%TYPE;
1881: -- l_xfer_organization_name VARCHAR2(60);
1882: l_xfer_organization_name hr_organization_units.name%TYPE;
1883: l_proj_org_id NUMBER;
1884: l_to_proj_org_id NUMBER;

Line 1882: l_xfer_organization_name hr_organization_units.name%TYPE;

1878: l_batch VARCHAR2(15); --Increased width for Bug#2218654
1879: -- UTF8 changes l_organization_name VARCHAR2(60);
1880: l_organization_name hr_organization_units.name%TYPE;
1881: -- l_xfer_organization_name VARCHAR2(60);
1882: l_xfer_organization_name hr_organization_units.name%TYPE;
1883: l_proj_org_id NUMBER;
1884: l_to_proj_org_id NUMBER;
1885: l_source_proj_org_id NUMBER;
1886: l_project_number VARCHAR2(25);

Line 2696: -- Bug: 1350945 Use hr_organization_units instead of

2692: AND mmt.transaction_id = p_transaction_id;
2693:
2694: ----------------------------------------------------------------------
2695: -- assign transaction org as expenditure org
2696: -- Bug: 1350945 Use hr_organization_units instead of
2697: -- hr_all_organization_units. hou is a view on top of
2698: -- haou and haou_tl (haou is a multilingual table, it shouldnt
2699: -- even have the translated column "name" as an attribute)
2700: ----------------------------------------------------------------------

Line 2705: FROM hr_organization_units hou

2701:
2702: l_stmt_num := 30;
2703: SELECT hou.name
2704: INTO l_organization_name
2705: FROM hr_organization_units hou
2706: WHERE hou.organization_id = p_exp_org_id;
2707:
2708: --bug2623664
2709:

Line 2728: FROM hr_organization_units hou

2724: IF (p_transfer_organization_id IS NOT NULL
2725: AND p_transaction_action_id = 3 AND p_to_project_id IS NOT NULL) THEN
2726: SELECT hou.name
2727: INTO l_xfer_organization_name
2728: FROM hr_organization_units hou
2729: WHERE hou.organization_id = p_transfer_organization_id;
2730:
2731: l_stmt_num := 40;
2732:

Line 6050: l_organization_name hr_organization_units.name%TYPE;

6046: PROCESS_ERROR EXCEPTION;
6047: CST_NO_EXP_ORG_FOR_DEPT EXCEPTION;
6048:
6049: --UTF8 changes l_organization_name VARCHAR2(60);
6050: l_organization_name hr_organization_units.name%TYPE;
6051: l_exp_type VARCHAR2(30);
6052: l_error_code VARCHAR2(240);
6053: l_error_explanation VARCHAR2(240);
6054: l_debug VARCHAR2(80);

Line 6157: hr_organization_units hou

6153: l_stmt_num := 30;
6154: SELECT hou.name
6155: INTO l_organization_name
6156: FROM bom_departments bd,
6157: hr_organization_units hou
6158: WHERE hou.organization_id =
6159: bd.pa_expenditure_org_id
6160: AND bd.organization_id = p_organization_id
6161: AND bd.department_id = p_department_id;