APPS.HRI_OLTP_DISC_WRKFRC dependencies on PER_SHARED_TYPES_VL

Line 461: , per_shared_types_vl pst1

457: , pst2.system_type_cd unit2_name
458: , pst3.system_type_cd unit3_name
459: , bgt.business_group_id business_group_id
460: from pqh_budgets bgt
461: , per_shared_types_vl pst1
462: , per_shared_types_vl pst2
463: , per_shared_types_vl pst3
464: where bgt.budget_id = p_budget_id
465: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 462: , per_shared_types_vl pst2

458: , pst3.system_type_cd unit3_name
459: , bgt.business_group_id business_group_id
460: from pqh_budgets bgt
461: , per_shared_types_vl pst1
462: , per_shared_types_vl pst2
463: , per_shared_types_vl pst3
464: where bgt.budget_id = p_budget_id
465: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
466: AND bgt.budget_unit2_id = pst2.shared_type_id (+)

Line 463: , per_shared_types_vl pst3

459: , bgt.business_group_id business_group_id
460: from pqh_budgets bgt
461: , per_shared_types_vl pst1
462: , per_shared_types_vl pst2
463: , per_shared_types_vl pst3
464: where bgt.budget_id = p_budget_id
465: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
466: AND bgt.budget_unit2_id = pst2.shared_type_id (+)
467: AND bgt.budget_unit3_id = pst3.shared_type_id (+);

Line 945: , per_shared_types_vl pst1

941: , pst2.system_type_cd unit2_name
942: , pst3.system_type_cd unit3_name
943: , bgt.business_group_id business_group_id
944: FROM pqh_budgets bgt
945: , per_shared_types_vl pst1
946: , per_shared_types_vl pst2
947: , per_shared_types_vl pst3
948: WHERE bgt.budget_id = p_budget_id
949: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 946: , per_shared_types_vl pst2

942: , pst3.system_type_cd unit3_name
943: , bgt.business_group_id business_group_id
944: FROM pqh_budgets bgt
945: , per_shared_types_vl pst1
946: , per_shared_types_vl pst2
947: , per_shared_types_vl pst3
948: WHERE bgt.budget_id = p_budget_id
949: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
950: AND bgt.budget_unit2_id = pst2.shared_type_id (+)

Line 947: , per_shared_types_vl pst3

943: , bgt.business_group_id business_group_id
944: FROM pqh_budgets bgt
945: , per_shared_types_vl pst1
946: , per_shared_types_vl pst2
947: , per_shared_types_vl pst3
948: WHERE bgt.budget_id = p_budget_id
949: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
950: AND bgt.budget_unit2_id = pst2.shared_type_id (+)
951: AND bgt.budget_unit3_id = pst3.shared_type_id (+);