APPS.OKL_AM_QUOTES_WF dependencies on HZ_PARTIES

Line 1826: FROM hz_parties hzp

1822: --get the recipient email address
1823: CURSOR c_recipient(p_recipient_id IN NUMBER)
1824: IS
1825: SELECT hzp.email_address email
1826: FROM hz_parties hzp
1827: WHERE hzp.party_id = p_recipient_id;
1828:
1829: -- get the sender email address
1830: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 2822: FROM hz_parties hzp

2818: --get the recipient email address
2819: CURSOR c_recipient (p_recipient_id IN varchar2)--ansethur 26-jul-2007 XMLP (p_recipient_id IN NUMBER)
2820: IS
2821: SELECT hzp.email_address email
2822: FROM hz_parties hzp
2823: WHERE hzp.party_id = to_number(p_recipient_id);--ansethur 26-jul-2007 XMLP added to_number
2824:
2825: -- get the sender email address
2826: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 4107: FROM hz_parties hzp

4103: --get the recipient email address
4104: CURSOR c_recipient(p_recipient_id IN NUMBER)
4105: IS
4106: SELECT hzp.email_address email
4107: FROM hz_parties hzp
4108: WHERE hzp.party_id = p_recipient_id;
4109:
4110: -- get the sender email address
4111: CURSOR c_agent_csr (c_agent_id NUMBER) IS

Line 4877: FROM hz_parties hzp

4873: --get the recipient email address
4874: CURSOR c_recipient(p_recipient_id IN NUMBER)
4875: IS
4876: SELECT hzp.email_address email
4877: FROM hz_parties hzp
4878: WHERE hzp.party_id = p_recipient_id;
4879:
4880: -- get the sender email address
4881: CURSOR c_agent_csr (c_agent_id NUMBER) IS