APPS.AMS_CHANNEL_PVT dependencies on HZ_PARTIES

Line 1288: 'HZ_PARTIES',

1284: END IF;
1285: --------------------- party_id ------------------------
1286: IF p_chan_rec.party_id <> FND_API.g_miss_num THEN
1287: IF AMS_Utility_PVT.check_fk_exists(
1288: 'HZ_PARTIES',
1289: 'party_id',
1290: p_chan_rec.party_id
1291: ) = FND_API.g_false
1292: THEN

Line 1831: FROM hz_parties

1827: l_party_name VARCHAR2(255);
1828:
1829: CURSOR c_party_name IS
1830: SELECT party_name
1831: FROM hz_parties
1832: WHERE party_id = p_party_id;
1833: BEGIN
1834: IF p_party_id IS NULL THEN
1835: RETURN NULL;

Line 1866: FROM hz_parties

1862: l_party_number VARCHAR2(30);
1863:
1864: CURSOR c_party_number IS
1865: SELECT party_number
1866: FROM hz_parties
1867: WHERE party_id = p_party_id;
1868: BEGIN
1869: IF p_party_id IS NULL THEN
1870: RETURN NULL;

Line 1900: FROM hz_parties

1896: l_party_type VARCHAR2(30);
1897:
1898: CURSOR c_party_type IS
1899: SELECT party_type
1900: FROM hz_parties
1901: WHERE party_id = p_party_id;
1902: BEGIN
1903: IF p_party_id IS NULL THEN
1904: RETURN NULL;