APPS.PQH_WORKFLOW dependencies on HR_LOOKUPS

Line 2333: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp

2329: from pqh_attributes_vl
2330: where attribute_id = p_attribute_id
2331: and nvl(enable_flag,'X') ='Y';
2332: cursor c2 is select sty.shared_type_name unit_name,lkp.description avail_desc
2333: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp
2334: where bgt.budget_id = l_budget_id
2335: and bgt.budget_unit1_aggregate = lkp.lookup_code
2336: and lkp.lookup_type ='PQH_BGT_UOM_AGGREGATE'
2337: and bgt.budget_unit1_id = sty.shared_type_id ;

Line 2339: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp

2335: and bgt.budget_unit1_aggregate = lkp.lookup_code
2336: and lkp.lookup_type ='PQH_BGT_UOM_AGGREGATE'
2337: and bgt.budget_unit1_id = sty.shared_type_id ;
2338: cursor c3 is select sty.shared_type_name unit_name, lkp.description avail_desc
2339: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp
2340: where bgt.budget_id = l_budget_id
2341: and bgt.budget_unit2_aggregate = lkp.lookup_code
2342: and lkp.lookup_type ='PQH_BGT_UOM_AGGREGATE'
2343: and bgt.budget_unit2_id = sty.shared_type_id ;

Line 2345: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp

2341: and bgt.budget_unit2_aggregate = lkp.lookup_code
2342: and lkp.lookup_type ='PQH_BGT_UOM_AGGREGATE'
2343: and bgt.budget_unit2_id = sty.shared_type_id ;
2344: cursor c4 is select sty.shared_type_name unit_name, lkp.description avail_desc
2345: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp
2346: where bgt.budget_id = l_budget_id
2347: and bgt.budget_unit3_aggregate = lkp.lookup_code
2348: and lkp.lookup_type ='PQH_BGT_UOM_AGGREGATE'
2349: and bgt.budget_unit3_id = sty.shared_type_id ;