APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 501: -- This is procedure to delete orphan records from BEN_PRTT_REIMBMT_RQST_F

497: -- ----------------------------------------------------------------------------
498: -- |-------------------------< delete_prtt_reimbmt_rqst_f >--------------------------|
499: -- ----------------------------------------------------------------------------
500: --
501: -- This is procedure to delete orphan records from BEN_PRTT_REIMBMT_RQST_F
502: -- where deleted person_id is directly referenced.
503: --
504: procedure delete_prtt_reimbmt_rqst_f
505: is

Line 515: DELETE FROM ben_prtt_reimbmt_rqst_f a

511: --
512: hr_utility.set_location ('Entering ' || l_proc, 5);
513: --
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

Line 523: ben_batch_utils.write(p_text => 'BEN_PRTT_REIMBMT_RQST_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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);
523: ben_batch_utils.write(p_text => 'BEN_PRTT_REIMBMT_RQST_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
524: --
525: hr_utility.set_location ('Leaving ' || l_proc, 10);
526: --
527: end delete_prtt_reimbmt_rqst_f;