eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APPLICATIONS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: from PER_ALL_ASSIGNMENTS_F paa,

82: -- Start of fix for WWBUG 1408379
83: --
84: cursor c1 is
85: select abv1.*
86: from PER_ALL_ASSIGNMENTS_F paa,
87: per_assignment_budget_values_f abv1
88: where paa.APPLICATION_ID = p_application_id
89: and paa.PERSON_ID = p_person_id
90: and paa.business_group_id = p_business_group_id

Line 116: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv

112: into p_del_flag
113: from sys.dual
114: where exists (
115: Select null
116: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
117: where paa.APPLICATION_ID = p_application_id
118: and paa.PERSON_ID = p_person_id
119: and paa.business_group_id + 0 = p_business_group_id
120: and paa.ASSIGNMENT_TYPE = 'A'

Line 136: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv1

132: --
133: delete from per_assignment_budget_values_f abv
134: where exists (
135: Select null
136: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv1
137: where paa.APPLICATION_ID = p_application_id
138: and paa.PERSON_ID = p_person_id
139: and paa.business_group_id + 0 = p_business_group_id
140: and paa.ASSIGNMENT_TYPE = 'A'

Line 164: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv

160: into p_del_flag
161: from sys.dual
162: where exists (
163: Select null
164: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
165: where paa.APPLICATION_ID = p_application_id
166: and paa.PERSON_ID = p_person_id
167: and paa.business_group_id + 0 = p_business_group_id
168: and paa.ASSIGNMENT_TYPE = 'A'

Line 263: from PER_ALL_ASSIGNMENTS_F paa,

259: -- Start of fix for WWBUG 1408379
260: --
261: cursor c1 is
262: select abv1.*
263: from PER_ALL_ASSIGNMENTS_F paa,
264: per_assignment_budget_values_f abv1
265: where paa.APPLICATION_ID = p_application_id
266: and paa.PERSON_ID = p_person_id
267: and paa.business_group_id = p_business_group_id

Line 291: from PER_ALL_ASSIGNMENTS_F paa

287: into p_del_flag
288: from sys.dual
289: where exists (
290: Select null
291: from PER_ALL_ASSIGNMENTS_F paa
292: where paa.APPLICATION_ID = p_application_id
293: and paa.PERSON_ID = p_person_id
294: and paa.business_group_id + 0 = p_business_group_id
295: and paa.ASSIGNMENT_TYPE = 'A'

Line 987: UPDATE PER_ALL_ASSIGNMENTS_F A

983: CLOSE c_chk_prv_status;
984: OPEN get_actve_apl;
985: FETCH get_actve_apl INTO v_act_ass_stat_id;
986: CLOSE get_actve_apl;
987: UPDATE PER_ALL_ASSIGNMENTS_F A
988: SET A.LAST_UPDATE_DATE = trunc(sysdate)
989: , A.LAST_UPDATED_BY = P_last_updated_by
990: , A.LAST_UPDATE_LOGIN = p_last_update_login
991: , A.EFFECTIVE_END_DATE = P_end_of_time

Line 1013: UPDATE PER_ALL_ASSIGNMENTS_F A

1009: ,p_last_update_login);
1010: --
1011: ELSE CLOSE c_chk_prv_status;
1012: --
1013: UPDATE PER_ALL_ASSIGNMENTS_F A
1014: SET A.LAST_UPDATE_DATE = trunc(sysdate)
1015: , A.LAST_UPDATED_BY = P_last_updated_by
1016: , A.LAST_UPDATE_LOGIN = p_last_update_login
1017: , A.EFFECTIVE_END_DATE = P_end_of_time

Line 1089: UPDATE PER_ALL_ASSIGNMENTS_F A

1085: CLOSE c_chk_prv_status;
1086: OPEN get_actve_apl;
1087: FETCH get_actve_apl INTO v_act_ass_stat_id;
1088: CLOSE get_actve_apl;
1089: UPDATE PER_ALL_ASSIGNMENTS_F A
1090: SET A.LAST_UPDATE_DATE = trunc(sysdate)
1091: , A.LAST_UPDATED_BY = P_last_updated_by
1092: , A.LAST_UPDATE_LOGIN = p_last_update_login
1093: , A.EFFECTIVE_END_DATE = P_end_of_time

Line 1115: UPDATE PER_ALL_ASSIGNMENTS_F A

1111: ,p_last_update_login);
1112: --
1113: ELSE CLOSE c_chk_prv_status;
1114: --
1115: UPDATE PER_ALL_ASSIGNMENTS_F A
1116: SET A.LAST_UPDATE_DATE = trunc(sysdate)
1117: , A.LAST_UPDATED_BY = P_last_updated_by
1118: , A.LAST_UPDATE_LOGIN = p_last_update_login
1119: , A.EFFECTIVE_END_DATE = P_end_of_time

Line 1160: -- FROM per_all_assignments_f a

1156: p_last_update_login NUMBER) IS
1157:
1158: -- CURSOR c_chk_assigns IS
1159: -- SELECT 1
1160: -- FROM per_all_assignments_f a
1161: -- WHERE a.application_id = P_application_id
1162: -- AND a.person_id = p_person_id
1163: -- AND a.business_group_id + 0 = p_business_group_id
1164: -- AND a.assignment_type = 'A'

Line 1171: from per_all_assignments_f a

1167: --dummy_assign NUMBER(1);
1168: --
1169: cursor csr_get_future_assignments is
1170: select assignment_id, object_version_number, effective_start_date
1171: from per_all_assignments_f a
1172: WHERE a.application_id = P_application_id
1173: AND a.person_id = p_person_id
1174: AND a.business_group_id = p_business_group_id
1175: AND a.assignment_type = 'A'

Line 1179: from per_all_assignments_f paf2

1175: AND a.assignment_type = 'A'
1176: AND a.effective_start_date > P_date_end
1177: AND not exists
1178: (select 'Y'
1179: from per_all_assignments_f paf2
1180: where paf2.assignment_id = a.assignment_id
1181: and paf2.effective_start_date < a.EFFECTIVE_START_DATE);
1182: --
1183: l_validation_start_date DATE;

Line 1207: DELETE per_all_assignments_f a

1203: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
1204: );
1205: END LOOP;
1206: -- Delete DT updates
1207: DELETE per_all_assignments_f a
1208: WHERE a.application_id = P_application_id
1209: AND a.person_id = p_person_id
1210: AND a.business_group_id = p_business_group_id
1211: AND a.assignment_type = 'A'

Line 1216: UPDATE per_all_assignments_f paa

1212: AND a.effective_start_date > P_date_end;
1213:
1214: -- Terminate assignments
1215:
1216: UPDATE per_all_assignments_f paa
1217: SET paa.last_update_date = trunc(sysdate),
1218: paa.last_updated_by = p_last_updated_by,
1219: paa.last_update_login = p_last_update_login,
1220: paa.EFFECTIVE_END_DATE = P_date_end

Line 1227: from PER_ALL_ASSIGNMENTS_F pa2

1223: and paa.business_group_id + 0 = p_business_group_id
1224: and paa.ASSIGNMENT_TYPE = 'A'
1225: and paa.EFFECTIVE_END_DATE =
1226: (select max(pa2.EFFECTIVE_END_DATE)
1227: from PER_ALL_ASSIGNMENTS_F pa2
1228: where pa2.PERSON_ID = p_person_id
1229: and pa2.assignment_id = paa.assignment_id -- 3957964 >>
1230: and pa2.effective_end_date > p_date_end -- <<
1231: and pa2.APPLICATION_ID = P_application_id);

Line 1337: FROM PER_ALL_ASSIGNMENTS_F PAAF

1333: p_business_group_id NUMBER,
1334: P_date_end DATE) IS
1335: CURSOR c_assign_changes IS
1336: SELECT 1
1337: FROM PER_ALL_ASSIGNMENTS_F PAAF
1338: WHERE PAAF.PERSON_ID = p_person_id
1339: AND PAAF.business_group_id + 0 = p_business_group_id
1340: AND PAAF.EFFECTIVE_START_DATE > P_date_end;
1341: ------

Line 2385: from per_all_assignments_f asg

2381: -- Bug 10286850
2382: l_person_id per_all_people_f.person_id%type;
2383: cursor csr_chk_emp is
2384: select asg.person_id
2385: from per_all_assignments_f asg
2386: where asg.application_id = p_application_id
2387: and asg.assignment_type = 'E'
2388: and asg.effective_start_date > p_date_received;
2389:

Line 2417: FROM per_all_assignments_f asg

2413: cursor future_apl_asg is
2414: SELECT asg.assignment_id
2415: ,asg.effective_start_date
2416: ,asg.effective_end_date
2417: FROM per_all_assignments_f asg
2418: ,per_assignment_status_types ast
2419: WHERE asg.effective_start_date > p_date_end
2420: AND asg.person_id = p_person_id
2421: AND asg.application_id = p_application_id

Line 2427: FROM per_all_assignments_f asg1

2423: AND ast.per_system_status = 'ACTIVE_APL'
2424: AND asg.assignment_id NOT IN
2425: (
2426: SELECT assignment_id
2427: FROM per_all_assignments_f asg1
2428: WHERE asg1.application_id = p_application_id
2429: AND asg1.person_id = p_person_id
2430: AND p_date_end BETWEEN asg1.effective_start_date AND asg1.effective_end_date)
2431: ORDER BY asg.effective_start_date;

Line 2475: update per_all_assignments_f

2471:
2472:
2473: hr_utility.set_location('Future APL exists on : '||apl.application_id,12);
2474: -- updating the assignments whose APL ID is in future with current APL ID
2475: update per_all_assignments_f
2476: set application_id = p_application_id
2477: where application_id = apl.application_id
2478: and person_id = p_person_id
2479: and assignment_type = 'A';

Line 2543: from per_all_assignments_f

2539: for asg_rec in future_apl_asg loop
2540:
2541: select max(effective_end_date)
2542: into l_apl_end_date
2543: from per_all_assignments_f
2544: where person_id = p_person_id
2545: and assignment_id = asg_rec.assignment_id
2546: and assignment_type = 'A';
2547:

Line 2587: update per_all_assignments_f

2583: end if;
2584: close chk_apl_exists;
2585:
2586: -- Updating the asgts with the new APLN Id
2587: update per_all_assignments_f
2588: set application_id = l_current_apl_id
2589: where person_id = p_person_id
2590: and application_id = p_application_id
2591: and assignment_id = asg_rec.assignment_id

Line 2792: l_assignment_id per_all_assignments_f.assignment_id%Type;

2788: p_application_id number,
2789: p_legislation_code varchar2,
2790: p_action varchar2) is
2791: --
2792: l_assignment_id per_all_assignments_f.assignment_id%Type;
2793: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2794: l_ass_status per_assignment_status_types.per_system_status%Type;
2795: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2796: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;

Line 2796: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;

2792: l_assignment_id per_all_assignments_f.assignment_id%Type;
2793: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2794: l_ass_status per_assignment_status_types.per_system_status%Type;
2795: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2796: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;
2797: --
2798: -- To get the assignment status based o the action (Termination or
2799: -- Reverse termination)
2800: cursor csr_get_asg_status is

Line 2818: from per_all_assignments_f paa

2814: -- To get all the assignment id's for the concerned application to be
2815: -- terminated
2816: cursor csr_term_ass_id is
2817: select paa.assignment_id
2818: from per_all_assignments_f paa
2819: where paa.application_id = p_application_id
2820: and paa.person_id = p_person_id
2821: and paa.business_group_id + 0 = p_business_group_id
2822: and paa.assignment_type = 'A'

Line 2825: from per_all_assignments_f pa2

2821: and paa.business_group_id + 0 = p_business_group_id
2822: and paa.assignment_type = 'A'
2823: and paa.effective_end_date =
2824: (select max(pa2.effective_end_date)
2825: from per_all_assignments_f pa2
2826: where pa2.person_id = p_person_id
2827: and pa2.application_id = p_application_id);
2828: --
2829: -- To get all the assignment id's for the concerned application to be

Line 2833: from per_all_assignments_f paa

2829: -- To get all the assignment id's for the concerned application to be
2830: -- reverse terminated
2831: cursor csr_cancel_ass_id is
2832: select paa.assignment_id
2833: from per_all_assignments_f paa
2834: where paa.application_id = p_application_id
2835: and paa.person_id = p_person_id
2836: and paa.business_group_id + 0 = p_business_group_id
2837: and paa.assignment_type = 'A'