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 830: from sys.dual

826: -- Select statement modified to improve performance.
827: --
828: select 'Y'
829: into l_delete_permitted
830: from sys.dual
831: where not exists (
832: select null
833: from per_letter_request_lines r
834: where r.person_id = P_PERSON_ID

Line 839: from sys.dual

835: and r.date_from >= p_effective_date );
836: --
837: select 'Y'
838: into l_delete_permitted
839: from sys.dual
840: where not exists (
841: select null
842: from per_letter_request_lines r
843: where exists (

Line 864: from sys.dual

860: begin
861: --
862: select 'Y'
863: into l_delete_permitted
864: from sys.dual
865: where not exists (
866: select null
867: from per_contact_relationships r
868: where r.person_id = P_PERSON_ID

Line 885: from sys.dual

881: begin
882: --
883: select 'Y'
884: into l_delete_permitted
885: from sys.dual
886: where not exists (
887: select null
888: from per_events e
889: where e.internal_contact_person_id = P_PERSON_ID);

Line 905: from sys.dual

901: begin
902: --
903: select 'Y'
904: into l_delete_permitted
905: from sys.dual
906: where not exists (
907: select null
908: from per_bookings b
909: where b.person_id = P_PERSON_ID);

Line 925: from sys.dual

921: begin
922: --
923: select 'Y'
924: into l_delete_permitted
925: from sys.dual
926: where 1 >= (
927: select count(*)
928: from per_assignments_f a
929: where a.person_id = P_PERSON_ID

Line 946: from sys.dual

942: begin
943: --
944: select 'Y'
945: into l_delete_permitted
946: from sys.dual
947: where not exists (
948: select null
949: from per_assignments_f a
950: where a.recruiter_id = P_PERSON_ID

Line 967: from sys.dual

963: begin
964: --
965: select 'Y'
966: into l_delete_permitted
967: from sys.dual
968: where not exists (
969: select null
970: from per_periods_of_service p
971: where p.termination_accepted_person_id = P_PERSON_ID);

Line 987: from sys.dual

983: begin
984: --
985: select 'Y'
986: into l_delete_permitted
987: from sys.dual
988: where not exists (
989: select null
990: from per_person_analyses a
991: where a.person_id = P_PERSON_ID);

Line 1007: from sys.dual

1003: begin
1004: --
1005: select 'Y'
1006: into l_delete_permitted
1007: from sys.dual
1008: where not exists (
1009: select null
1010: from per_absence_attendances a
1011: where a.person_id = P_PERSON_ID);

Line 1027: from sys.dual

1023: begin
1024: --
1025: select 'Y'
1026: into l_delete_permitted
1027: from sys.dual
1028: where not exists (
1029: select null
1030: from per_absence_attendances a
1031: where a.authorising_person_id = P_PERSON_ID

Line 1048: from sys.dual

1044: begin
1045: --
1046: select 'Y'
1047: into l_delete_permitted
1048: from sys.dual
1049: where not exists (
1050: select null
1051: from per_recruitment_activities r
1052: where r.authorising_person_id = P_PERSON_ID

Line 1069: from sys.dual

1065: begin
1066: --
1067: select 'Y'
1068: into l_delete_permitted
1069: from sys.dual
1070: where not exists (
1071: select null
1072: from per_appraisals apr
1073: where apr.appraisee_person_id = P_PERSON_ID

Line 1090: from sys.dual

1086: begin
1087: --
1088: select 'Y'
1089: into l_delete_permitted
1090: from sys.dual
1091: where not exists (
1092: select null
1093: from per_participants par
1094: where par.person_id = P_PERSON_ID);

Line 1110: from sys.dual

1106: begin
1107: --
1108: select 'Y'
1109: into l_delete_permitted
1110: from sys.dual
1111: where not exists (
1112: select null
1113: from per_requisitions r
1114: where r.person_id = P_PERSON_ID);

Line 1130: from sys.dual

1126: begin
1127: --
1128: select 'Y'
1129: into l_delete_permitted
1130: from sys.dual
1131: where not exists (
1132: select null
1133: from per_vacancies v
1134: where v.recruiter_id = P_PERSON_ID);

Line 1152: from sys.dual

1148: begin
1149: --
1150: select 'Y'
1151: into l_delete_permitted
1152: from sys.dual
1153: where not exists (
1154: select null
1155: from pay_element_entries_f e,
1156: per_assignments_f a,

Line 1180: from sys.dual

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

Line 1203: from sys.dual

1199: begin
1200: --
1201: select 'Y'
1202: into l_delete_permitted
1203: from sys.dual
1204: where not exists (
1205: select null
1206: from per_assignment_extra_info i
1207: where exists (

Line 1227: from sys.dual

1223: begin
1224: --
1225: select 'Y'
1226: into l_delete_permitted
1227: from sys.dual
1228: where not exists (
1229: select null
1230: from per_secondary_ass_statuses s
1231: where exists (

Line 1251: from sys.dual

1247: begin
1248: --
1249: select 'Y'
1250: into l_delete_permitted
1251: from sys.dual
1252: where not exists (
1253: select null
1254: from per_events e
1255: where exists (

Line 1275: from sys.dual

1271: begin
1272: --
1273: select 'Y'
1274: into l_delete_permitted
1275: from sys.dual
1276: where not exists (
1277: select null
1278: from per_spinal_point_placements_f p
1279: where exists (

Line 1299: from sys.dual

1295: begin
1296: --
1297: select 'Y'
1298: into l_delete_permitted
1299: from sys.dual
1300: where not exists (
1301: select null
1302: from per_quickpaint_result_text t
1303: where exists (

Line 1323: from sys.dual

1319: begin
1320: --
1321: select 'Y'
1322: into l_delete_permitted
1323: from sys.dual
1324: where not exists (
1325: select null
1326: from per_cobra_cov_enrollments c
1327: where exists (

Line 2255: from sys.dual

2251: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2252: begin
2253: select 1
2254: into l_dummy
2255: from sys.dual
2256: where exists (
2257: select null
2258: from per_participants par
2259: where par.person_id = P_PERSON_ID);

Line 2289: from sys.dual

2285: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2286: begin
2287: select 2
2288: into l_dummy
2289: from sys.dual
2290: where exists (
2291: select null
2292: from per_appraisals apr
2293: where (apr.appraiser_person_id = P_PERSON_ID