APPS.PVX_PRTNR_PRFLS_PVT dependencies on HZ_PARTIES

Line 1038: FROM hz_parties

1034: AND object_id = p_partner_party_id;
1035:
1036: CURSOR c_party_status (p_party_id IN NUMBER) IS
1037: SELECT NVL(status, 'A') party_status
1038: FROM hz_parties
1039: WHERE party_id = p_party_id;
1040:
1041: CURSOR c_resource_status (p_resource_id IN NUMBER) IS
1042: SELECT start_date_active,

Line 1208: 'HZ_PARTIES', -- Parent schema object having the primary key

1204:
1205: ----------------------- partner_id ------------------------
1206: IF p_prtnr_prfls_rec.partner_id <> FND_API.g_miss_num THEN
1207: IF PVX_Utility_PVT.check_fk_exists(
1208: 'HZ_PARTIES', -- Parent schema object having the primary key
1209: 'PARTY_ID', -- Column name in the parent object that maps to the fk value
1210: p_prtnr_prfls_rec.partner_id, -- Value of fk to be validated against the parent object's pk column
1211: PVX_utility_PVT.g_number -- datatype of fk
1212: ) = FND_API.g_false