DBA Data[Home] [Help]

APPS.JTF_TTY_NA_WF dependencies on FND_LOOKUPS

Line 576: from fnd_lookups lkp,

572: BEGIN
573:
574: select lkp.lookup_code
575: into l_site_type_code
576: from fnd_lookups lkp,
577: hz_parties hzp
578: where lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
579: and hzp.hq_branch_ind = lkp.lookup_code
580: and hzp.party_id = p_party_id;

Line 608: from fnd_lookups lkp

604: BEGIN
605: site_type_code := get_site_type_code(p_party_id);
606: select lkp.meaning
607: into x_party_type
608: from fnd_lookups lkp
609: where lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
610: and lkp.lookup_code = site_type_code;
611:
612: END get_site_type;