APPS.PA_TIMELINE_PVT dependencies on PA_RESOURCES_DENORM

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 258: pa_resources_denorm resdenorm, HR_ORGANIZATION_INFORMATION_V hoi

254: AND jtf_res.primary_calendar_flag = 'Y'
255: UNION ALL
256: SELECT res.resource_id, resdenorm.resource_effective_start_date start_date,
257: TO_DATE('12/31/4712','MM/DD/YYYY') end_date from pa_resources res,
258: pa_resources_denorm resdenorm, HR_ORGANIZATION_INFORMATION_V hoi
259: where res.jtf_resource_id is null
260: and res.resource_id=resdenorm.resource_id and res.resource_type_id = 101 -- Bug 4370196
261: and p_calendar_id = hoi.ORG_INFORMATION1 and resdenorm.resource_org_id = hoi.organization_id -- Bug#14017517 Start
262: and hoi.org_information_context = 'Resource Defaults'

Line 264: from pa_resources_denorm where resource_id=resdenorm.resource_id ); -- Bug#14017517 end

260: and res.resource_id=resdenorm.resource_id and res.resource_type_id = 101 -- Bug 4370196
261: and p_calendar_id = hoi.ORG_INFORMATION1 and resdenorm.resource_org_id = hoi.organization_id -- Bug#14017517 Start
262: and hoi.org_information_context = 'Resource Defaults'
263: and resdenorm.resource_effective_start_date = (select max(resource_effective_start_date)
264: from pa_resources_denorm where resource_id=resdenorm.resource_id ); -- Bug#14017517 end
265:
266: li_commit_size NUMBER:=1;
267: pi_commit_size NUMBER :=1000;
268: