APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.

110: begin
111: --
112: -- bug 2840328:PA HR UPDATE TRIGGERS SHOULD NOT CREATE WF PROCESS IF NO RELEVANT CHANGES
113: -- We should not start workflow when no attribute of interest to PA has not been
114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.
115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND

Line 176: IF p_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN

172:
173: wf_engine.threshold := -1 ;
174:
175:
176: IF p_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
177: l_process := 'PROCESS_ASSIGNMENT_CHANGES' ;
178:
179: ELSIF p_table_name = 'PER_ORG_STRUCTURE_ELEMENTS' THEN
180:

Line 2431: from per_all_assignments_f asgn,

2427: --
2428: --Bug 9762784 Start
2429: CURSOR chk_asgn (l_person_id NUMBER, l_start_date_new DATE) IS
2430: select 'Y'
2431: from per_all_assignments_f asgn,
2432: per_assignment_status_types status
2433: where asgn.person_id = l_person_id
2434: and trunc(l_start_date_new) between trunc(asgn.effective_start_date) and trunc(asgn.effective_end_date)
2435: and asgn.assignment_type in ('E', 'C')