APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on FND_LOOKUPS

Line 416: FROM fnd_lookups lkp, hz_parties hzp

412: END IF;
413:
414: BEGIN
415: SELECT lkp.lookup_code INTO l_site_type_code
416: FROM fnd_lookups lkp, hz_parties hzp
417: WHERE lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
418: AND hzp.hq_branch_ind = lkp.lookup_code
419: AND hzp.party_id = p_party_id;
420:

Line 3396: FROM fnd_lookups

3392: /* check for invalid delete flag */
3393: BEGIN
3394: SELECT lookup_code
3395: INTO p_delete_flag_code
3396: FROM fnd_lookups
3397: WHERE lookup_type = 'JTF_TERR_FLAGS'
3398: AND upper(meaning) = upper(p_delete_flag)
3399: AND rownum < 2;
3400: EXCEPTION