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.BEN_DELETE_ORPHAN_ROWS dependencies on PER_ALL_PEOPLE_F

Line 86: from per_all_people_f ppf );

82: --
83: delete /*+ parallel(a) */ from per_contact_relationships a
84: where a.contact_person_id is not null
85: and a.contact_person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
86: from per_all_people_f ppf );
87: --
88: delete /*+ parallel(a) */ from per_contact_relationships a
89: where a.person_id is not null
90: and a.person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id

Line 91: from per_all_people_f ppf );

87: --
88: delete /*+ parallel(a) */ from per_contact_relationships a
89: where a.person_id is not null
90: and a.person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
91: from per_all_people_f ppf );
92: --
93:
94: ben_batch_utils.write(p_text => 'PER_CONTACT_RELATIOSHSHIPS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
95: --

Line 120: FROM per_all_people_f per

116: --
117: --
118: DELETE FROM ben_cbr_quald_bnf a
119: WHERE NOT EXISTS (SELECT 1
120: FROM per_all_people_f per
121: WHERE per.person_id = a.cvrd_emp_person_id);
122: --
123: --
124: ben_batch_utils.write(p_text => 'BEN_CBR_QUALD_BNF : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

Line 150: FROM per_all_people_f per

146: --
147: --
148: DELETE FROM ben_crt_ordr a
149: WHERE NOT EXISTS (SELECT 1
150: FROM per_all_people_f per
151: WHERE per.person_id = a.person_id);
152: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
153: --
154: hr_utility.set_location ('Leaving ' || l_proc, 10);

Line 178: FROM per_all_people_f per

174: --
175: --
176: DELETE FROM ben_crt_ordr_cvrd_per a
177: WHERE NOT EXISTS (SELECT 1
178: FROM per_all_people_f per
179: WHERE per.person_id = a.person_id);
180: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR_CVRD_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
181: --
182: hr_utility.set_location ('Leaving ' || l_proc, 10);

Line 207: FROM per_all_people_f per);

203: --
204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a
205: WHERE a.dpnt_person_id IS NOT NULL
206: AND a.dpnt_person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
207: FROM per_all_people_f per);
208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
209: --
210: hr_utility.set_location ('Leaving ' || l_proc, 10);
211: --

Line 235: FROM per_all_people_f per);

231: --
232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a
233: WHERE a.person_id IS NOT NULL
234: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
235: FROM per_all_people_f per);
236: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
237: --
238: hr_utility.set_location ('Leaving ' || l_proc, 10);
239: --

Line 263: FROM per_all_people_f per);

259: --
260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a
261: WHERE a.person_id IS NOT NULL
262: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
263: FROM per_all_people_f per);
264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
265: --
266: hr_utility.set_location ('Leaving ' || l_proc, 10);
267: --

Line 292: FROM per_all_people_f per);

288: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_dtl a
289: WHERE a.person_id IS NOT NULL
290: AND a.person_id NOT IN (0, 999999999999)
291: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
292: FROM per_all_people_f per);
293: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_DTL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
294: --
295: hr_utility.set_location ('Leaving ' || l_proc, 10);
296: --

Line 320: FROM per_all_people_f per);

316: --
317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a
318: WHERE a.person_id IS NOT NULL
319: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
320: FROM per_all_people_f per);
321: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_ERR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
322: --
323: hr_utility.set_location ('Leaving ' || l_proc, 10);
324: --

Line 348: FROM per_all_people_f per);

344: --
345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a
346: WHERE a.person_id IS NOT NULL
347: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
348: FROM per_all_people_f per);
349: ben_batch_utils.write(p_text => 'BEN_LE_CLSN_N_RSTR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
350: --
351: hr_utility.set_location ('Leaving ' || l_proc, 10);
352: --

Line 376: FROM per_all_people_f per);

372: --
373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a
374: WHERE a.person_id IS NOT NULL
375: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
376: FROM per_all_people_f per);
377: ben_batch_utils.write(p_text => 'BEN_PERSON_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
378: --
379: hr_utility.set_location ('Leaving ' || l_proc, 10);
380: --

Line 403: FROM per_all_people_f per

399: --
400: --
401: DELETE FROM ben_per_bnfts_bal_f a
402: WHERE NOT EXISTS (SELECT 1
403: FROM per_all_people_f per
404: WHERE per.person_id = a.person_id);
405: ben_batch_utils.write(p_text => 'BEN_PER_BNFTS_BAL_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
406: --
407: hr_utility.set_location ('Leaving ' || l_proc, 10);

Line 431: FROM per_all_people_f per

427: --
428: --
429: DELETE FROM ben_per_dlvry_mthd_f a
430: WHERE NOT EXISTS (SELECT 1
431: FROM per_all_people_f per
432: WHERE per.person_id = a.person_id);
433: ben_batch_utils.write(p_text => 'BEN_PER_DLVRY_MTHD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
434: --
435: hr_utility.set_location ('Leaving ' || l_proc, 10);

Line 459: FROM per_all_people_f per

455: --
456: --
457: DELETE FROM ben_per_pin_f a
458: WHERE NOT EXISTS (SELECT 1
459: FROM per_all_people_f per
460: WHERE per.person_id = a.person_id);
461: ben_batch_utils.write(p_text => 'BEN_PER_PIN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
462: --
463: hr_utility.set_location ('Leaving ' || l_proc, 10);

Line 488: FROM per_all_people_f per

484: --
485: DELETE FROM ben_pl_bnf_f a
486: WHERE NOT EXISTS (
487: SELECT 1
488: FROM per_all_people_f per
489: WHERE per.person_id = a.bnf_person_id
490: OR per.person_id = a.ttee_person_id);
491: ben_batch_utils.write(p_text => 'BEN_PL_BNF_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
492: --

Line 518: FROM per_all_people_f per

514: --
515: DELETE FROM ben_prtt_reimbmt_rqst_f a
516: WHERE NOT EXISTS (
517: SELECT 1
518: FROM per_all_people_f per
519: WHERE per.person_id = a.submitter_person_id
520: OR per.person_id = a.recipient_person_id
521: OR per.person_id = a.provider_person_id
522: OR per.person_id = a.provider_ssn_person_id);

Line 550: FROM per_all_people_f per);

546: --
547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a
548: WHERE a.person_id IS NOT NULL
549: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
550: FROM per_all_people_f per);
551: ben_batch_utils.write(p_text => 'BEN_PTNL_LER_FOR_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
552: --
553: hr_utility.set_location ('Leaving ' || l_proc, 10);
554: --

Line 591: FROM per_all_people_f per);

587: DISTINCT benefit_action_id
588: FROM ben_benefit_actions a
589: WHERE a.person_id IS NOT NULL
590: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
591: FROM per_all_people_f per);
592: --
593: begin
594: --
595: hr_utility.set_location ('Entering ' || l_proc, 5);

Line 718: FROM per_all_people_f per);

714: DISTINCT per_in_ler_id
715: FROM ben_per_in_ler a
716: WHERE a.person_id IS NOT NULL
717: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
718: FROM per_all_people_f per);
719: --
720: begin
721: --
722: hr_utility.set_location ('Entering ' || l_proc, 5);

Line 847: FROM per_all_people_f per);

843: DISTINCT prtt_enrt_rslt_id
844: FROM ben_prtt_enrt_rslt_f a
845: WHERE a.person_id IS NOT NULL
846: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
847: FROM per_all_people_f per);
848: --
849: begin
850: --
851: hr_utility.set_location ('Entering ' || l_proc, 5);

Line 928: FROM per_all_people_f per

924: SELECT /*+ PARALLEL(A) */
925: DISTINCT elig_cvrd_dpnt_id
926: FROM ben_elig_cvrd_dpnt_f a
927: WHERE NOT EXISTS (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL(PER) */ 1
928: FROM per_all_people_f per
929: WHERE per.person_id = a.dpnt_person_id);
930: --
931: begin
932: --

Line 998: FROM per_all_people_f per

994: SELECT /*+ PARALLEL(A) */
995: DISTINCT per_cm_id
996: FROM ben_per_cm_f a
997: WHERE NOT EXISTS (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL(PER) */ 1
998: FROM per_all_people_f per
999: WHERE per.person_id = a.person_id);
1000: --
1001: begin
1002: --