APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_PARTIES

Line 545: FROM HZ_PARTIES PARTY

541: --Obtain the new lessee name
542: CURSOR c_lessee(p_party_id IN NUMBER) IS
543: SELECT party_id,
544: PARTY_NAME
545: FROM HZ_PARTIES PARTY
546: WHERE PARTY_ID = p_party_id;
547:
548: CURSOR c_taa_record(p_tcn_id IN NUMBER) IS
549: SELECT *

Line 610: FROM hz_parties hzp,

606: p_party_id IN NUMBER) IS
607: SELECT hzp.party_id,
608: hzp.party_name contact_name,
609: hzp.email_address email
610: FROM hz_parties hzp,
611: hz_cust_account_roles hzc
612: WHERE hzc.cust_account_id = p_cust_account_id
613: AND hzc.status = 'A'
614: AND hzc.role_type = 'CONTACT'

Line 834: FROM HZ_PARTIES PARTY

830:
831: --Obtain the insurer/insurance_agent name
832: CURSOR c_lessee(p_party_id IN NUMBER) IS
833: SELECT PARTY_NAME
834: FROM HZ_PARTIES PARTY
835: WHERE PARTY_ID = p_party_id;
836:
837:
838: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;