APPS.JTF_TTY_NA_TERRGP dependencies on FND_LOOKUPS

Line 108: FROM fnd_lookups lkp,

104: BEGIN
105:
106: SELECT lkp.lookup_code
107: INTO l_site_type_code
108: FROM fnd_lookups lkp,
109: hz_parties hzp
110: WHERE lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
111: AND hzp.hq_branch_ind = lkp.lookup_code
112: AND hzp.party_id = p_party_id;

Line 141: FROM fnd_lookups lkp

137: site_type_code := get_site_type_code(p_party_id);
138:
139: SELECT lkp.meaning
140: INTO x_party_type
141: FROM fnd_lookups lkp
142: WHERE lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
143: AND lkp.lookup_code = site_type_code;
144:
145: --

Line 1796: FROM fnd_lookups l

1792: AND gt.rsc_group_id = p_group_id ;
1793:
1794: CURSOR site_codes_c IS
1795: SELECT lookup_code site_type_code
1796: FROM fnd_lookups l
1797: WHERE lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
1798:
1799: CURSOR salesrep_named_accounts_c
1800: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts