APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_GET_RESOURCE

Line 4993: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

4989: Pa_Event_Types
4990: Where
4991: Event_Type = P_Fin_Cat_Name
4992: And Event_Type_Classification IN ('AUTOMATIC','MANUAL','WRITE OFF','WRITE ON')
4993: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
4994: 'Y',Start_Date_Active,
4995: Trunc(SysDate)) Between Start_Date_Active
4996: And Nvl(End_Date_Active,Trunc(SysDate));
4997:

Line 5005: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

5001: From
5002: Pa_Expenditure_Types
5003: Where
5004: lower(Expenditure_Type) = lower(P_Fin_Cat_Name)
5005: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5006: 'Y',Start_Date_Active,
5007: Trunc(SysDate)) Between Start_Date_Active
5008: And Nvl(End_Date_Active,Trunc(SysDate));
5009:

Line 5017: And Decode(Pa_Get_Resource.Include_Inactive_Resources,

5013: From
5014: Pa_Expenditure_Categories
5015: Where
5016: lower(Expenditure_Category) = lower(P_Fin_Cat_Name)
5017: And Decode(Pa_Get_Resource.Include_Inactive_Resources,
5018: 'Y',Start_Date_Active,
5019: Trunc(SysDate)) Between Start_Date_Active
5020: And Nvl(End_Date_Active,Trunc(SysDate));
5021: