27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address 31: FROM hz_parties hzp, fnd_user fu 32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;
34:
35: begin