APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on PA_RESOURCES_DENORM

Line 138: -- because we don't need to update pa_resources_denorm.

134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;
136:
137: -- When the trigger on PER_JOB_EXTRA_INFO is fired, we won't launch the WF in following cases
138: -- because we don't need to update pa_resources_denorm.
139: -- If 'Include in Utilization' Falg=N, we don't need to pull thos corresponding resources. So
140: -- there won't be any resources to update..
141: ELSIF p_table_name= 'PER_JOB_EXTRA_INFO' THEN
142: IF ( p_calling_mode='INSERT' AND (p_jei_information3_new='N' OR p_jei_information3_new IS NULL)) THEN

Line 1970: FROM pa_resources_denorm

1966: select 'Y'
1967: into l_org_res_exists
1968: from dual
1969: where exists (SELECT 'Y'
1970: FROM pa_resources_denorm
1971: WHERE resource_organization_id = l_org_id
1972: and sysdate between resource_effective_start_date and
1973: resource_effective_end_date
1974: AND rownum = 1

Line 1977: FROM pa_resources_denorm

1973: resource_effective_end_date
1974: AND rownum = 1
1975: UNION ALL
1976: SELECT 'Y'
1977: FROM pa_resources_denorm
1978: WHERE resource_organization_id = l_org_id
1979: and resource_effective_start_date > sysdate
1980: AND rownum = 1);
1981:

Line 2703: then the corresponding assignment in pa_resources_denorm must be

2699: if (l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2700: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'N') then
2701:
2702: /*If the assignments organization does not belong to expenditure hierarchy
2703: then the corresponding assignment in pa_resources_denorm must be
2704: end dated
2705: */
2706: pa_hr_update_api.Update_EndDate(
2707: p_person_id => l_person_id,

Line 2747: -- pa_resources_denorm. This check is required because a new

2743:
2744: --dbms_output.put_line('Primary flags are same');
2745:
2746: -- The code below checks if record exists for update in
2747: -- pa_resources_denorm. This check is required because a new
2748: -- assignment creation in HR only updates the default HR
2749: -- assignment. So the new assignment will not exist in PRM
2750:
2751: -- Bug 4352255 - performance improvement - change to where exists

Line 2762: FROM pa_resources_denorm

2758: SELECT 'Y'
2759: INTO l_res_asgn_exists
2760: FROM dual
2761: WHERE EXISTS (SELECT 'Y'
2762: FROM pa_resources_denorm
2763: WHERE person_id = l_person_id
2764: AND resource_effective_start_date =
2765: l_start_date_new);
2766: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3392: FROM pa_resources_denorm

3388:
3389: IF l_return_status = 'S' THEN
3390: SELECT max(resource_effective_end_date)
3391: INTO l_resource_effective_end_date
3392: FROM pa_resources_denorm
3393: WHERE person_id = l_person_id;
3394:
3395: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3396: PA_HR_UPDATE_API.withdraw_cand_nominations