APPS.HRI_EDW_FCT_RECRUITMENT dependencies on HRI_RECRUITMENT_STAGES

Line 486: DELETE FROM hri_recruitment_stages;

482: l_termination_reason VARCHAR2(30);
483:
484: BEGIN
485:
486: DELETE FROM hri_recruitment_stages;
487:
488: FOR new_asg_rec IN initial_assignment_cursor LOOP
489:
490: g_application_date := TO_DATE(null);

Line 554: INSERT INTO hri_recruitment_stages

550: -- , 'FTE'
551: -- , new_asg_rec.assignment_start );
552:
553:
554: INSERT INTO hri_recruitment_stages
555: ( assignment_id
556: , assignment_start_date
557: , business_group_id
558: , assignment_type