APPS.HRI_OPL_WRKFC_EVENTS dependencies on HRI_MB_ASGN_EVENTS_CT

Line 1710: hri_mb_asgn_events_ct evt

1706: ,evt.event_id adt_event_id
1707: ,evt.business_group_id adt_business_group_id
1708: ,evt.performance_review_id adt_perf_review_id
1709: FROM
1710: hri_mb_asgn_events_ct evt
1711: WHERE evt.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
1712: AND evt.summarization_rqd_ind = 1
1713: ) wevt
1714: WHERE wevt.pow_powband_fk = pow.pow_band_sk_pk

Line 2203: ,hri_mb_asgn_events_ct evt

2199: ,evt.performance_review_id adt_perf_review_id
2200: ,eq.erlst_evnt_effective_date adt_event_date
2201: FROM
2202: hri_eq_wrkfc_evt eq
2203: ,hri_mb_asgn_events_ct evt
2204: WHERE evt.assignment_id = eq.assignment_id
2205: AND evt.effective_change_end_date >= eq.erlst_evnt_effective_date - 1
2206: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
2207: AND evt.summarization_rqd_ind = 1

Line 2477: FROM hri_mb_asgn_events_ct

2473: -- Set the SQL statement for the entire range
2474: p_sqlstr :=
2475: 'SELECT /*+ PARALLEL(asg, DEFAULT, DEFAULT) */ DISTINCT
2476: assignment_id object_id
2477: FROM hri_mb_asgn_events_ct
2478: ORDER BY assignment_id';
2479:
2480: END IF;
2481:

Line 2569: FROM hri_mb_asgn_events_ct

2565: ,CEIL(ROWNUM / 20) chunk_no
2566: FROM
2567: (SELECT DISTINCT
2568: assignment_id
2569: FROM hri_mb_asgn_events_ct
2570: ORDER BY assignment_id
2571: ) tab
2572: ) chunks
2573: GROUP BY