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.HR_PERSON_INTERNAL dependencies on DUAL

Line 97: from sys.dual

93: begin
94: --
95: select 'Y'
96: into l_delete_permitted
97: from sys.dual
98: where not exists
99: (select null
100: from fnd_user aol
101: where aol.employee_id = P_PERSON_ID

Line 130: from sys.dual

126: BEGIN
127: --
128: select 'Y'
129: into l_delete_permitted
130: from sys.dual
131: where not exists
132: (select null
133: from per_assignments_f ass,
134: hr_assignment_set_amendments asa

Line 172: from sys.dual

168: begin
169: --
170: select 'Y'
171: into l_delete_permitted
172: from sys.dual
173: where not exists
174: (select null
175: from pay_assignment_actions paa
176: ,per_assignments_f ass

Line 282: from sys.dual

278: begin
279: --
280: select 'Y'
281: into l_delete_permitted
282: from sys.dual
283: where not exists
284: (select null
285: from per_assignments_f a
286: ,per_contact_relationships c

Line 328: from sys.dual

324: -- the person is deleted
325: --
326: select null
327: into l_delete_permitted
328: from sys.dual
329: where not exists
330: (select null
331: from per_contracts_f
332: where person_id = p_person_id);

Line 387: from sys.dual

383: begin
384: --
385: select 'Y'
386: into l_contact_elsewhere
387: from sys.dual
388: where exists
389: (select null
390: from per_contact_relationships r
391: where r.contact_relationship_id <> P_CONTACT_RELATIONSHIP_ID

Line 410: from sys.dual

406: begin
407: --
408: select 'Y'
409: into l_other_only
410: from sys.dual
411: where not exists
412: (select null
413: from per_people_f p
414: where p.person_id = P_CONTACT_PERSON_ID

Line 859: from sys.dual

855: -- Select statement modified to improve performance.
856: --
857: select 'Y'
858: into l_delete_permitted
859: from sys.dual
860: where not exists (
861: select null
862: from per_letter_request_lines r
863: where r.person_id = P_PERSON_ID

Line 868: from sys.dual

864: and r.date_from >= p_effective_date );
865: --
866: select 'Y'
867: into l_delete_permitted
868: from sys.dual
869: where not exists (
870: select null
871: from per_letter_request_lines r
872: where exists (

Line 893: from sys.dual

889: begin
890: --
891: select 'Y'
892: into l_delete_permitted
893: from sys.dual
894: where not exists (
895: select null
896: from per_contact_relationships r
897: where r.person_id = P_PERSON_ID

Line 914: from sys.dual

910: begin
911: --
912: select 'Y'
913: into l_delete_permitted
914: from sys.dual
915: where not exists (
916: select null
917: from per_events e
918: where e.internal_contact_person_id = P_PERSON_ID);

Line 934: from sys.dual

930: begin
931: --
932: select 'Y'
933: into l_delete_permitted
934: from sys.dual
935: where not exists (
936: select null
937: from per_bookings b
938: where b.person_id = P_PERSON_ID);

Line 954: from sys.dual

950: begin
951: --
952: select 'Y'
953: into l_delete_permitted
954: from sys.dual
955: where 1 >= (
956: select count(*)
957: from per_assignments_f a
958: where a.person_id = P_PERSON_ID

Line 975: from sys.dual

971: begin
972: --
973: select 'Y'
974: into l_delete_permitted
975: from sys.dual
976: where not exists (
977: select null
978: from per_assignments_f a
979: where a.recruiter_id = P_PERSON_ID

Line 996: from sys.dual

992: begin
993: --
994: select 'Y'
995: into l_delete_permitted
996: from sys.dual
997: where not exists (
998: select null
999: from per_periods_of_service p
1000: where p.termination_accepted_person_id = P_PERSON_ID);

Line 1016: from sys.dual

1012: begin
1013: --
1014: select 'Y'
1015: into l_delete_permitted
1016: from sys.dual
1017: where not exists (
1018: select null
1019: from per_person_analyses a
1020: where a.person_id = P_PERSON_ID);

Line 1036: from sys.dual

1032: begin
1033: --
1034: select 'Y'
1035: into l_delete_permitted
1036: from sys.dual
1037: where not exists (
1038: select null
1039: from per_absence_attendances a
1040: where a.person_id = P_PERSON_ID);

Line 1056: from sys.dual

1052: begin
1053: --
1054: select 'Y'
1055: into l_delete_permitted
1056: from sys.dual
1057: where not exists (
1058: select null
1059: from per_absence_attendances a
1060: where a.authorising_person_id = P_PERSON_ID

Line 1077: from sys.dual

1073: begin
1074: --
1075: select 'Y'
1076: into l_delete_permitted
1077: from sys.dual
1078: where not exists (
1079: select null
1080: from per_recruitment_activities r
1081: where r.authorising_person_id = P_PERSON_ID

Line 1098: from sys.dual

1094: begin
1095: --
1096: select 'Y'
1097: into l_delete_permitted
1098: from sys.dual
1099: where not exists (
1100: select null
1101: from per_appraisals apr
1102: where apr.appraisee_person_id = P_PERSON_ID

Line 1119: from sys.dual

1115: begin
1116: --
1117: select 'Y'
1118: into l_delete_permitted
1119: from sys.dual
1120: where not exists (
1121: select null
1122: from per_participants par
1123: where par.person_id = P_PERSON_ID);

Line 1139: from sys.dual

1135: begin
1136: --
1137: select 'Y'
1138: into l_delete_permitted
1139: from sys.dual
1140: where not exists (
1141: select null
1142: from per_requisitions r
1143: where r.person_id = P_PERSON_ID);

Line 1159: from sys.dual

1155: begin
1156: --
1157: select 'Y'
1158: into l_delete_permitted
1159: from sys.dual
1160: where not exists (
1161: select null
1162: from per_vacancies v
1163: where v.recruiter_id = P_PERSON_ID);

Line 1181: from sys.dual

1177: begin
1178: --
1179: select 'Y'
1180: into l_delete_permitted
1181: from sys.dual
1182: where not exists (
1183: select null
1184: from pay_element_entries_f e,
1185: per_assignments_f a,

Line 1209: from sys.dual

1205: begin
1206: --
1207: select 'Y'
1208: into l_delete_permitted
1209: from sys.dual
1210: where not exists (
1211: select null
1212: from pay_element_entries_f e,
1213: per_assignments_f a

Line 1232: from sys.dual

1228: begin
1229: --
1230: select 'Y'
1231: into l_delete_permitted
1232: from sys.dual
1233: where not exists (
1234: select null
1235: from per_assignment_extra_info i
1236: where exists (

Line 1256: from sys.dual

1252: begin
1253: --
1254: select 'Y'
1255: into l_delete_permitted
1256: from sys.dual
1257: where not exists (
1258: select null
1259: from per_secondary_ass_statuses s
1260: where exists (

Line 1280: from sys.dual

1276: begin
1277: --
1278: select 'Y'
1279: into l_delete_permitted
1280: from sys.dual
1281: where not exists (
1282: select null
1283: from per_events e
1284: where exists (

Line 1304: from sys.dual

1300: begin
1301: --
1302: select 'Y'
1303: into l_delete_permitted
1304: from sys.dual
1305: where not exists (
1306: select null
1307: from per_spinal_point_placements_f p
1308: where exists (

Line 1328: from sys.dual

1324: begin
1325: --
1326: select 'Y'
1327: into l_delete_permitted
1328: from sys.dual
1329: where not exists (
1330: select null
1331: from per_quickpaint_result_text t
1332: where exists (

Line 1352: from sys.dual

1348: begin
1349: --
1350: select 'Y'
1351: into l_delete_permitted
1352: from sys.dual
1353: where not exists (
1354: select null
1355: from per_cobra_cov_enrollments c
1356: where exists (

Line 2287: from sys.dual

2283: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2284: begin
2285: select 1
2286: into l_dummy
2287: from sys.dual
2288: where exists (
2289: select null
2290: from per_participants par
2291: where par.person_id = P_PERSON_ID);

Line 2321: from sys.dual

2317: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2318: begin
2319: select 2
2320: into l_dummy
2321: from sys.dual
2322: where exists (
2323: select null
2324: from per_appraisals apr
2325: where (apr.appraiser_person_id = P_PERSON_ID