DBA Data[Home] [Help]

APPS.PON_FORMS_UTIL_PVT dependencies on FND_LOOKUPS

Line 4331: -- get send to email from fnd_lookups

4327: select email_address into l_buyer_email
4328: from WF_LOCAL_ROLES
4329: where NAME = p_from_role_name;
4330:
4331: -- get send to email from fnd_lookups
4332: select meaning, enabled_flag, start_date_active, end_date_active
4333: into l_email_to,l_email_enabled,l_email_start_date,l_email_end_date
4334: from fnd_lookups
4335: where lookup_type ='PON_FBO_EMAIL'

Line 4334: from fnd_lookups

4330:
4331: -- get send to email from fnd_lookups
4332: select meaning, enabled_flag, start_date_active, end_date_active
4333: into l_email_to,l_email_enabled,l_email_start_date,l_email_end_date
4334: from fnd_lookups
4335: where lookup_type ='PON_FBO_EMAIL'
4336: and lookup_code = 'EMAIL_TO';
4337:
4338: --Email to does not setup properly in lookup, raise error.

Line 4346: -- get cc email from fnd_lookups

4342: sysdate >l_email_end_date)then
4343: raise PON_INVALID_EMAIL_TO_EXCEPTION;
4344: end if;
4345:
4346: -- get cc email from fnd_lookups
4347: select meaning
4348: into l_email_cc
4349: from fnd_lookups
4350: where lookup_type = 'PON_FBO_EMAIL'

Line 4349: from fnd_lookups

4345:
4346: -- get cc email from fnd_lookups
4347: select meaning
4348: into l_email_cc
4349: from fnd_lookups
4350: where lookup_type = 'PON_FBO_EMAIL'
4351: and lookup_code = 'EMAIL_CC';
4352:
4353: