APPS.CST_PRJMFG_COST_COLLECTOR dependencies on HR_ORGANIZATION_UNITS

Line 1941: l_organization_name hr_organization_units.name%TYPE;

1937: l_stmt_num NUMBER;
1938:
1939: l_batch VARCHAR2(15); --Increased width for Bug#2218654
1940: -- UTF8 changes l_organization_name VARCHAR2(60);
1941: l_organization_name hr_organization_units.name%TYPE;
1942: -- l_xfer_organization_name VARCHAR2(60);
1943: l_xfer_organization_name hr_organization_units.name%TYPE;
1944: l_proj_org_id NUMBER;
1945: l_to_proj_org_id NUMBER;

Line 1943: l_xfer_organization_name hr_organization_units.name%TYPE;

1939: l_batch VARCHAR2(15); --Increased width for Bug#2218654
1940: -- UTF8 changes l_organization_name VARCHAR2(60);
1941: l_organization_name hr_organization_units.name%TYPE;
1942: -- l_xfer_organization_name VARCHAR2(60);
1943: l_xfer_organization_name hr_organization_units.name%TYPE;
1944: l_proj_org_id NUMBER;
1945: l_to_proj_org_id NUMBER;
1946: l_source_proj_org_id NUMBER;
1947: l_project_number VARCHAR2(25);

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

2753: AND mmt.transaction_id = p_transaction_id;
2754:
2755: ----------------------------------------------------------------------
2756: -- assign transaction org as expenditure org
2757: -- Bug: 1350945 Use hr_organization_units instead of
2758: -- hr_all_organization_units. hou is a view on top of
2759: -- haou and haou_tl (haou is a multilingual table, it shouldnt
2760: -- even have the translated column "name" as an attribute)
2761: ----------------------------------------------------------------------

Line 2766: FROM hr_organization_units hou

2762:
2763: l_stmt_num := 30;
2764: SELECT hou.name
2765: INTO l_organization_name
2766: FROM hr_organization_units hou
2767: WHERE hou.organization_id = p_exp_org_id;
2768:
2769: --bug2623664
2770:

Line 2789: FROM hr_organization_units hou

2785: IF (p_transfer_organization_id IS NOT NULL
2786: AND p_to_project_id IS NOT NULL AND (p_transaction_action_id = 3 OR p_transaction_action_id = 21)) THEN
2787: SELECT hou.name
2788: INTO l_xfer_organization_name
2789: FROM hr_organization_units hou
2790: WHERE hou.organization_id = p_transfer_organization_id;
2791:
2792: l_stmt_num := 40;
2793:

Line 6177: l_organization_name hr_organization_units.name%TYPE;

6173: PROCESS_ERROR EXCEPTION;
6174: CST_NO_EXP_ORG_FOR_DEPT EXCEPTION;
6175:
6176: --UTF8 changes l_organization_name VARCHAR2(60);
6177: l_organization_name hr_organization_units.name%TYPE;
6178: l_exp_type VARCHAR2(30);
6179: l_error_code VARCHAR2(240);
6180: l_error_explanation VARCHAR2(240);
6181: l_debug VARCHAR2(80);

Line 6284: hr_organization_units hou

6280: l_stmt_num := 30;
6281: SELECT hou.name
6282: INTO l_organization_name
6283: FROM bom_departments bd,
6284: hr_organization_units hou
6285: WHERE hou.organization_id =
6286: bd.pa_expenditure_org_id
6287: AND bd.organization_id = p_organization_id
6288: AND bd.department_id = p_department_id;