APPS.CST_PRJMFG_COST_COLLECTOR dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1576: From hr_all_organization_units_tl haout

1572: Bug 2124765 */
1573:
1574: if wt_rec.c_business_group_id is not null THEN
1575: Select haout.name into l_business_group_name
1576: From hr_all_organization_units_tl haout
1577: WHERE
1578: haout.organization_id = wt_rec.c_business_group_id
1579: AND haout.language = USERENV('LANG');
1580: end if;

Line 1916: l_recv_iss_organization_name hr_all_organization_units.name%TYPE;

1912: CST_FAILED_STD_CG_FLAG EXCEPTION;
1913: CST_FAILED_TXN_SRC EXCEPTION;
1914:
1915: -- UTF8 changes l_recv_iss_organization_name VARCHAR2(60);
1916: l_recv_iss_organization_name hr_all_organization_units.name%TYPE;
1917: l_primary_cost_method_snd NUMBER ;
1918: l_cost_collection_enabled_snd NUMBER ;
1919: l_return_status VARCHAR2(1);
1920: l_msg_count NUMBER;

Line 2697: -- hr_all_organization_units. hou is a view on top of

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: ----------------------------------------------------------------------
2701:

Line 2717: FROM hr_all_organization_units haou

2713: p_transaction_action_id = 6)
2714: AND p_type_class = 1 ) THEN
2715: SELECT haou.name
2716: INTO l_recv_iss_organization_name
2717: FROM hr_all_organization_units haou
2718: WHERE haou.organization_id = p_organization_id;
2719: END IF;
2720:
2721: