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 1127: FROM hz_parties hzp

1123: --get the recipient email address
1124: CURSOR c_recipient(p_recipient_id IN NUMBER)
1125: IS
1126: SELECT hzp.email_address email
1127: FROM hz_parties hzp
1128: WHERE hzp.party_id = p_recipient_id;
1129:
1130: -- get the sender email address
1131: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 1358: FROM hz_parties hzp

1354: --get the recipient email address
1355: CURSOR c_recipient(p_recipient_id IN NUMBER)
1356: IS
1357: SELECT hzp.email_address email
1358: FROM hz_parties hzp
1359: WHERE hzp.party_id = p_recipient_id;
1360:
1361: -- get the sender email address
1362: CURSOR c_agent_csr (c_agent_id NUMBER) IS