DBA Data[Home] [Help]

APPS.MST_AGG_PKG dependencies on FND_PROFILE

Line 5810: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');

5806: and hzc.party_id = hzp.party_id;
5807:
5808: -- p_party_id is orgnization_id from mst_delivery_details
5809: elsif l_location_source_code = 'HR' then
5810: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');
5811: end if;
5812: return l_owner_name;
5813: end;
5814:

Line 5871: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');

5867: fetch carriers into l_owner_name;
5868: end if;
5869:
5870: elsif l_location_source_code = 'HR' then
5871: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');
5872: end if;
5873: return l_owner_name;
5874: end;
5875:

Line 5942: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');

5938: end if;
5939: end if;
5940:
5941: elsif l_location_source_code = 'HR' then
5942: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');
5943: end if;
5944: return l_owner_name;
5945: end;
5946: