APPS.HRI_OPL_SUP_ABSNC dependencies on HRI_EQ_SUP_ABSNC

Line 301: ,hri_eq_sup_absnc eq

297: ,abs_dim.abs_person_id
298: FROM
299: hri_mb_utl_absnc_ct abs_fct
300: ,hri_cs_absence_ct abs_dim
301: ,hri_eq_sup_absnc eq
302: WHERE abs_dim.absence_sk_pk = eq.source_id
303: AND eq.source_type = 'ABSENCE'
304: AND eq.source_id BETWEEN p_start_abs_id
305: AND p_end_abs_id

Line 509: FROM hri_eq_sup_absnc eq

505: -- Delete changed rows
506: DELETE FROM hri_mdp_sup_absnc_occ_ct tab
507: WHERE tab.absence_sk_fk IN
508: (SELECT eq.source_id
509: FROM hri_eq_sup_absnc eq
510: WHERE eq.source_id BETWEEN p_start_abs_id AND p_end_abs_id
511: AND eq.source_type = 'ABSENCE');
512:
513: -- Reset PL/SQL tables

Line 568: INSERT INTO hri_eq_sup_absnc

564:
565: BEGIN
566:
567: -- Insert absences affected by supervisor changes
568: INSERT INTO hri_eq_sup_absnc
569: (source_id
570: ,source_type)
571: SELECT
572: dim.absence_sk_pk source_id

Line 576: ,hri_eq_sup_absnc eq

572: dim.absence_sk_pk source_id
573: ,'ABSENCE' source_type
574: FROM
575: hri_cs_absence_ct dim
576: ,hri_eq_sup_absnc eq
577: WHERE eq.source_type = 'SUPERVISOR'
578: AND eq.source_id = dim.abs_person_id
579: AND dim.abs_end_date >= eq.erlst_evnt_effective_date
580: AND NOT EXISTS

Line 582: FROM hri_eq_sup_absnc eq_abs

578: AND eq.source_id = dim.abs_person_id
579: AND dim.abs_end_date >= eq.erlst_evnt_effective_date
580: AND NOT EXISTS
581: (SELECT null
582: FROM hri_eq_sup_absnc eq_abs
583: WHERE eq_abs.source_id = dim.absence_sk_pk
584: AND eq_abs.source_type = 'ABSENCE');
585:
586: commit;

Line 660: FROM hri_eq_sup_absnc

656: -- Set the SQL statement for the incremental range
657: p_sqlstr :=
658: 'SELECT
659: source_id object_id
660: FROM hri_eq_sup_absnc
661: WHERE source_type = ''ABSENCE''
662: ORDER BY source_id';
663:
664: END IF;

Line 714: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_SUP_ABSNC';

710: p_table_owner => l_schema);
711: END IF;
712:
713: -- Empty out absence summary event queue
714: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_SUP_ABSNC';
715: EXECUTE IMMEDIATE(l_sql_stmt);
716:
717: END post_process;
718:

Line 752: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_eq_sup_absnc';

748: process_range_incr(0, l_end_abs_id);
749: END IF;
750:
751: -- Truncate table
752: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_eq_sup_absnc';
753:
754: END single_thread_process;
755:
756: END hri_opl_sup_absnc;