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 3398: FROM fnd_lookups

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