APPS.OKL_AM_ASSET_RETURN_WF dependencies on HZ_PARTIES

Line 367: FROM hz_parties hzp

363: --get the recipient email address
364: CURSOR c_recipient(p_recipient_id IN NUMBER)
365: IS
366: SELECT hzp.email_address email
367: FROM hz_parties hzp
368: WHERE hzp.party_id = p_recipient_id;
369:
370: -- get the sender email address
371: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 1172: FROM hz_parties hzp

1168: --get the recipient email address
1169: CURSOR c_recipient(p_recipient_id IN NUMBER)
1170: IS
1171: SELECT hzp.email_address email
1172: FROM hz_parties hzp
1173: WHERE hzp.party_id = p_recipient_id;
1174:
1175: -- get the sender email address
1176: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 1403: FROM hz_parties hzp

1399: --get the recipient email address
1400: CURSOR c_recipient(p_recipient_id IN NUMBER)
1401: IS
1402: SELECT hzp.email_address email
1403: FROM hz_parties hzp
1404: WHERE hzp.party_id = p_recipient_id;
1405:
1406: -- get the sender email address
1407: CURSOR c_agent_csr (c_agent_id NUMBER) IS