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 1055: -- FROM per_all_assignments_f a

1051: p_last_update_login NUMBER) IS
1052:
1053: -- CURSOR c_chk_assigns IS
1054: -- SELECT 1
1055: -- FROM per_all_assignments_f a
1056: -- WHERE a.application_id = P_application_id
1057: -- AND a.person_id = p_person_id
1058: -- AND a.business_group_id + 0 = p_business_group_id
1059: -- AND a.assignment_type = 'A'

Line 1066: from per_all_assignments_f a

1062: --dummy_assign NUMBER(1);
1063: --
1064: cursor csr_get_future_assignments is
1065: select assignment_id, object_version_number, effective_start_date
1066: from per_all_assignments_f a
1067: WHERE a.application_id = P_application_id
1068: AND a.person_id = p_person_id
1069: AND a.business_group_id = p_business_group_id
1070: AND a.assignment_type = 'A'

Line 1074: from per_all_assignments_f paf2

1070: AND a.assignment_type = 'A'
1071: AND a.effective_start_date > P_date_end
1072: AND not exists
1073: (select 'Y'
1074: from per_all_assignments_f paf2
1075: where paf2.assignment_id = a.assignment_id
1076: and paf2.effective_start_date < a.EFFECTIVE_START_DATE);
1077: --
1078: l_validation_start_date DATE;

Line 1102: DELETE per_all_assignments_f a

1098: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
1099: );
1100: END LOOP;
1101: -- Delete DT updates
1102: DELETE per_all_assignments_f a
1103: WHERE a.application_id = P_application_id
1104: AND a.person_id = p_person_id
1105: AND a.business_group_id = p_business_group_id
1106: AND a.assignment_type = 'A'

Line 1111: UPDATE per_all_assignments_f paa

1107: AND a.effective_start_date > P_date_end;
1108:
1109: -- Terminate assignments
1110:
1111: UPDATE per_all_assignments_f paa
1112: SET paa.last_update_date = trunc(sysdate),
1113: paa.last_updated_by = p_last_updated_by,
1114: paa.last_update_login = p_last_update_login,
1115: paa.EFFECTIVE_END_DATE = P_date_end

Line 1122: from PER_ALL_ASSIGNMENTS_F pa2

1118: and paa.business_group_id + 0 = p_business_group_id
1119: and paa.ASSIGNMENT_TYPE = 'A'
1120: and paa.EFFECTIVE_END_DATE =
1121: (select max(pa2.EFFECTIVE_END_DATE)
1122: from PER_ALL_ASSIGNMENTS_F pa2
1123: where pa2.PERSON_ID = p_person_id
1124: and pa2.assignment_id = paa.assignment_id -- 3957964 >>
1125: and pa2.effective_end_date > p_date_end -- <<
1126: and pa2.APPLICATION_ID = P_application_id);

Line 1215: FROM PER_ALL_ASSIGNMENTS_F PAAF

1211: p_business_group_id NUMBER,
1212: P_date_end DATE) IS
1213: CURSOR c_assign_changes IS
1214: SELECT 1
1215: FROM PER_ALL_ASSIGNMENTS_F PAAF
1216: WHERE PAAF.PERSON_ID = p_person_id
1217: AND PAAF.business_group_id + 0 = p_business_group_id
1218: AND PAAF.EFFECTIVE_START_DATE > P_date_end;
1219: ------

Line 2440: l_assignment_id per_all_assignments_f.assignment_id%Type;

2436: p_application_id number,
2437: p_legislation_code varchar2,
2438: p_action varchar2) is
2439: --
2440: l_assignment_id per_all_assignments_f.assignment_id%Type;
2441: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2442: l_ass_status per_assignment_status_types.per_system_status%Type;
2443: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2444: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;

Line 2444: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;

2440: l_assignment_id per_all_assignments_f.assignment_id%Type;
2441: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2442: l_ass_status per_assignment_status_types.per_system_status%Type;
2443: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2444: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;
2445: --
2446: -- To get the assignment status based o the action (Termination or
2447: -- Reverse termination)
2448: cursor csr_get_asg_status is

Line 2466: from per_all_assignments_f paa

2462: -- To get all the assignment id's for the concerned application to be
2463: -- terminated
2464: cursor csr_term_ass_id is
2465: select paa.assignment_id
2466: from per_all_assignments_f paa
2467: where paa.application_id = p_application_id
2468: and paa.person_id = p_person_id
2469: and paa.business_group_id + 0 = p_business_group_id
2470: and paa.assignment_type = 'A'

Line 2473: from per_all_assignments_f pa2

2469: and paa.business_group_id + 0 = p_business_group_id
2470: and paa.assignment_type = 'A'
2471: and paa.effective_end_date =
2472: (select max(pa2.effective_end_date)
2473: from per_all_assignments_f pa2
2474: where pa2.person_id = p_person_id
2475: and pa2.application_id = p_application_id);
2476: --
2477: -- To get all the assignment id's for the concerned application to be

Line 2481: from per_all_assignments_f paa

2477: -- To get all the assignment id's for the concerned application to be
2478: -- reverse terminated
2479: cursor csr_cancel_ass_id is
2480: select paa.assignment_id
2481: from per_all_assignments_f paa
2482: where paa.application_id = p_application_id
2483: and paa.person_id = p_person_id
2484: and paa.business_group_id + 0 = p_business_group_id
2485: and paa.assignment_type = 'A'