APPS.HRI_OPL_SUPH_HST dependencies on HRI_CS_ASGN_SUPH_EVENTS_CT

Line 1511: hri_cs_asgn_suph_events_ct ase

1507: ,ase.assignment_status_type_id
1508: ,ase.effective_end_date
1509: ,ase.assignment_type
1510: FROM
1511: hri_cs_asgn_suph_events_ct ase
1512: WHERE ase.primary_flag = 'Y'
1513: AND v_effective_date BETWEEN ase.effective_start_date
1514: AND ase.effective_end_date
1515: ) hier

Line 1537: hri_cs_asgn_suph_events_ct ase

1533: ELSE LEAST(ase.effective_end_date, ADD_MONTHS(v_effective_date, 1))
1534: END
1535: ,ase.assignment_type
1536: FROM
1537: hri_cs_asgn_suph_events_ct ase
1538: WHERE ase.person_id = p_person_id
1539: AND ase.primary_flag = 'Y'
1540: AND v_effective_date BETWEEN ase.effective_start_date
1541: AND ase.effective_end_date;

Line 1786: FROM hri_cs_asgn_suph_events_ct

1782:
1783: -- Get the earliest assignment record
1784: SELECT MIN(effective_start_date)
1785: INTO l_loop_date
1786: FROM hri_cs_asgn_suph_events_ct
1787: WHERE person_id = p_person_id
1788: AND primary_flag = 'Y';
1789:
1790: -- If the earliest assignment record exists and is later than

Line 1978: hri_cs_asgn_suph_events_ct ase

1974: CURSOR person_csr_full IS
1975: SELECT DISTINCT
1976: ase.person_id
1977: FROM
1978: hri_cs_asgn_suph_events_ct ase
1979: WHERE ase.person_id BETWEEN p_start_object_id and p_end_object_id
1980: AND ase.effective_end_date >= g_refresh_start_date;
1981:
1982: CURSOR person_csr_incr IS

Line 2114: FROM hri_cs_asgn_suph_events_ct

2110:
2111: -- Set the SQL statement for the entire range
2112: p_sqlstr :=
2113: 'SELECT DISTINCT person_id object_id
2114: FROM hri_cs_asgn_suph_events_ct
2115: ORDER BY person_id';
2116:
2117: -- ***************************
2118: -- Incremental refresh section

Line 2255: FROM hri_cs_asgn_suph_events_ct

2251: PROCEDURE full_refresh_single IS
2252:
2253: CURSOR psn_csr IS
2254: SELECT DISTINCT person_id
2255: FROM hri_cs_asgn_suph_events_ct
2256: WHERE primary_flag = 'Y';
2257:
2258: l_dummy VARCHAR2(32000);
2259: