APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_PARTIES

Line 502: FROM HZ_PARTIES PARTY

498: --Obtain the new lessee name
499: CURSOR c_lessee(p_party_id IN NUMBER) IS
500: SELECT party_id,
501: PARTY_NAME
502: FROM HZ_PARTIES PARTY
503: WHERE PARTY_ID = p_party_id;
504:
505: CURSOR c_taa_record(p_tcn_id IN NUMBER) IS
506: SELECT *

Line 564: FROM hz_parties hzp,

560: p_party_id IN NUMBER) IS
561: SELECT hzp.party_id,
562: hzp.party_name contact_name,
563: hzp.email_address email
564: FROM hz_parties hzp,
565: hz_cust_account_roles hzc
566: WHERE hzc.cust_account_id = p_cust_account_id
567: AND hzc.status = 'A'
568: AND hzc.role_type = 'CONTACT'

Line 788: FROM HZ_PARTIES PARTY

784:
785: --Obtain the insurer/insurance_agent name
786: CURSOR c_lessee(p_party_id IN NUMBER) IS
787: SELECT PARTY_NAME
788: FROM HZ_PARTIES PARTY
789: WHERE PARTY_ID = p_party_id;
790:
791:
792: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;