[Home] [Help]
224: a.Node_Type = 'TARIFF_CONTRACT' and a.Entity_Id = p_rec.Tariff_Contract_Code And
225: b.Node_Type = 'EMP_TYPE' and b.Entity_Id = l_Emp_Type and
226: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And
227: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
228: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
229: Type = 'REMUNERATION_REGULATION' AND
230: a.Hierarchy_Id = b.Hierarchy_Id And
231: p_effective_date between a.Date_From and Nvl(a.Date_To,Trunc(Sysdate)) and
232: b.Business_Group_Id=p_rec.Business_Group_Id
278: a.Node_Type = 'TARIFF_GROUP' and a.Entity_Id = p_rec.Tariff_Group_Code And
279: b.Node_Type = 'TARIFF_CONTRACT' and b.Entity_Id = p_rec.Tariff_Contract_Code and
280: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And
281: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
282: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
283: Type = 'REMUNERATION_REGULATION' AND
284: a.Hierarchy_Id = b.Hierarchy_Id And
285: p_effective_date between a.Date_From and Nvl(a.Date_To,Trunc(Sysdate)) and
286: b.Business_Group_Id=p_rec.Business_Group_Id ) and
331: e.Hierarchy_Node_Id = d.Parent_Hierarchy_Node_Id and
332: f.Hierarchy_Node_Id = e.Parent_Hierarchy_Node_Id and
333: g.Hierarchy_Node_Id = f.Parent_Hierarchy_Node_Id and
334: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
335: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
336: Type = 'REMUNERATION_REGULATION' AND
337: a.Hierarchy_Id = b.Hierarchy_Id And
338: p_Effective_Date between
339: a.Date_From and Nvl(a.Date_To,Trunc(Sysdate))and