APPS.PA_TIMELINE_PVT dependencies on PA_RESOURCES

Line 110: FROM pa_resources_denorm res

106: -- MOAC Changes : Bug 4363092: In R12 Rebuild Timeline Program should process all resources across OUs
107: -- Hence removing the client_info filter
108: CURSOR cur_res_det IS
109: SELECT distinct res.resource_id resource_id
110: FROM pa_resources_denorm res
111: WHERE upper(res.resource_name) BETWEEN upper(p_start_resource_name) AND upper(p_end_resource_name)
112: -- AND NVL(res.resource_org_id,NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
113: -- ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))), -99)) =
114: -- NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),

Line 118: FROM pa_resources_denorm res

114: -- NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
115: -- ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
116: UNION ALL
117: SELECT distinct res.resource_id resource_id
118: FROM pa_resources_denorm res
119: WHERE res.resource_id = p_resource_id;
120:
121:
122: cur_res_det_rec cur_res_det%ROWTYPE;

Line 250: FROM jtf_cal_resource_assign jtf_res,pa_resources pares

246: CURSOR cur_clndar IS
247: SELECT pares.resource_id resource_id,
248: trunc(start_date_time) start_date,
249: NVL(trunc(end_date_time), TO_DATE('12/31/4712','MM/DD/YYYY')) end_date
250: FROM jtf_cal_resource_assign jtf_res,pa_resources pares
251: WHERE jtf_res.resource_id = pares.jtf_resource_id
252: AND jtf_res.resource_type_code = 'RS_EMPLOYEE'
253: AND jtf_res.calendar_id = p_calendar_id
254: AND jtf_res.primary_calendar_flag = 'Y'

Line 259: from pa_resources res, pa_resources_denorm resdenorm

255: UNION ALL
256: SELECT res.resource_id,
257: resdenorm.resource_effective_start_date start_date,
258: TO_DATE('12/31/4712','MM/DD/YYYY') end_date
259: from pa_resources res, pa_resources_denorm resdenorm
260: where res.jtf_resource_id is null
261: and res.resource_id = resdenorm.resource_id
262: and res.resource_type_id = 101 -- Bug 4370196
263: ;