DevOps, CI/CD and Automation

Hi, When I pass the single query without union then report is working fine otherwise when I make union of two queries then I m getting the error:
ORA-00972 Identifier is too long.

FUNCTION REP_COURSE_RECERT(p_completed IN sis_application.desc_pgm_placement_status_id%TYPE,
p_registered IN sis_application.desc_pgm_placement_status_id%TYPE,
p_college_id IN pse_education_pgm_session.delivery_institution_id%TYPE,
p_start_dt IN course_session.recertify_dte%TYPE,
p_end_dt IN course_session.recertify_dte%TYPE,
p_tuition IN sis_payment_owing.desc_payment_item_id%TYPE,
p_program_sponsor IN sis_payment_owing.desc_payment_item_id%TYPE,
p_seat_sponsor IN sis_payment_owing.desc_payment_item_id%TYPE,
p_cs_join_coord IN VARCHAR2,
p_cs_join_sponsor IN VARCHAR2)
Return REP_COURSE_RECERT_CUR_D IS

REP_COURSE_RECERT_CUR_1 REP_COURSE_RECERT_CUR_D;

BEGIN
OPEN REP_COURSE_RECERT_CUR_1 FOR

-- Jeff Moser Aug 8, 2002 Education program table change
-- changed reference to sis_education_pgm_session table to pse_education_pgm_session table


'SELECT distinct e.pse_organization_id,
b.pse_education_pgm_session_id,
a.pse_education_course_id,
a.course_name,
c.pse_individual_id,
ocsm_common.f_get_individual_name(c.pse_individual_id),
b.recertify_dte
FROM pse_education_course a,
course_session b,
sis_application c,
pse_education_pgm_session d,
sis_payment_owing e,
sis_education_pgm_session f
WHERE a.pse_education_course_id = b.pse_education_course_id
AND b.pse_education_pgm_session_id = c.pse_education_pgm_session_id
AND (c.desc_pgm_placement_status_id = '|| p_completed
||' OR c.desc_pgm_placement_status_id = ' ||p_registered||')'
|| ' AND c.pse_education_pgm_session_id = d.pse_education_pgm_session_id
AND a.recertify_period_units is not null
AND d.delivery_institution_id = ' || p_college_id
|| ' AND b.recertify_dte >= '||''''||p_start_dt||''''|| ' and b.recertify_dte <=' ||''''||p_end_dt||''''
|| 'AND e.desc_payment_item_id in (' ||p_tuition||',' ||p_program_sponsor||',' ||p_seat_sponsor||')'
|| ' AND e.sis_application_id = c.sis_application_id
AND f.pse_education_pgm_session_id = d.pse_education_pgm_session_id'
|| p_cs_join_coord
|| p_cs_join_sponsor

||' UNION

SELECT distinct e.pse_organization_id,
b.pse_education_pgm_session_id,
a.pse_education_course_id,
a.course_name,
c.pse_individual_id,
ocsm_common.f_get_individual_name(c.pse_individual_id) ,
b.recertify_dte
FROM pse_education_course a,
course_session b,
sis_application c,
pse_education_pgm_session d,
sis_payment_owing e,
sis_education_pgm_session f,
sis_pgm_sponsor_seat_purch g
WHERE a.pse_education_course_id = b.pse_education_course_id
AND b.pse_education_pgm_session_id = c.pse_education_pgm_session_id
AND (c.desc_pgm_placement_status_id = '||p_completed
|| ' OR c.desc_pgm_placement_status_id = '||p_registered||')'
|| 'AND c.pse_education_pgm_session_id = d.pse_education_pgm_session_id
AND a.recertify_period_units is not null
AND d.delivery_institution_id = '||p_college_id
|| 'AND b.recertify_dte >=' ||''''||p_start_dt||''''||'and b.recertify_dte <=' ||''''||p_end_dt||''''
|| 'AND e.sis_pgm_sponsor_seat_purch_id = g.sis_pgm_sponsor_seat_purch_id
AND e.desc_payment_item_id in (' ||p_tuition||',' ||p_program_sponsor||','||p_seat_sponsor||')'
||'AND g.pse_education_pgm_session_id = b.pse_education_pgm_session_id
AND f.pse_education_pgm_session_id = d.pse_education_pgm_session_id'
|| p_cs_join_coord
|| p_cs_join_sponsor
||'ORDER BY 6';