APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_GET_RESOURCE

Line 5051: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

5047: Pa_Event_Types
5048: Where
5049: Event_Type = P_Fin_Cat_Name
5050: And Event_Type_Classification IN ('AUTOMATIC','MANUAL','WRITE OFF','WRITE ON')
5051: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5052: 'Y',Start_Date_Active,
5053: Trunc(SysDate)) Between Start_Date_Active
5054: And Nvl(End_Date_Active,Trunc(SysDate));
5055:

Line 5063: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

5059: From
5060: Pa_Expenditure_Types
5061: Where
5062: lower(Expenditure_Type) = lower(P_Fin_Cat_Name)
5063: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5064: 'Y',Start_Date_Active,
5065: Trunc(SysDate)) Between Start_Date_Active
5066: And Nvl(End_Date_Active,Trunc(SysDate));
5067:

Line 5075: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

5071: From
5072: Pa_Expenditure_Categories
5073: Where
5074: lower(Expenditure_Category) = lower(P_Fin_Cat_Name)
5075: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5076: 'Y',Start_Date_Active,
5077: Trunc(SysDate)) Between Start_Date_Active
5078: And Nvl(End_Date_Active,Trunc(SysDate));
5079: