APPS.PON_REMINDER_NOTIFICATION_PKG dependencies on FND_USER

Line 443: SELECT USER_NAME INTO p_supplier_role_name FROM FND_USER

439:
440: IF p_supplier_contact_id IS NOT NULL THEN
441:
442: BEGIN
443: SELECT USER_NAME INTO p_supplier_role_name FROM FND_USER
444: WHERE person_party_id = l_TP_contact_id_table(i)
445: AND SYSDATE BETWEEN start_date AND nvl(end_date,SYSDATE+1);
446: EXCEPTION
447: WHEN TOO_MANY_ROWS THEN

Line 455: FROM FND_USER

451: END IF;
452:
453: SELECT USER_NAME
454: INTO p_supplier_role_name
455: FROM FND_USER
456: WHERE person_party_id = l_TP_contact_id_table(i)
457: AND SYSDATE BETWEEN start_date AND nvl(end_date,SYSDATE+1)
458: AND ROWNUM = 1;
459: