DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on HZ_PARTIES

Line 1395: ,HZ_PARTIES hp

1391: l_return_status VARCHAR2(1) := 'S';
1392:
1393: CURSOR l_party_csr(cp_case_number in varchar2) IS SELECT hp.party_name
1394: FROM IEX_CASES_ALL_B ica
1395: ,HZ_PARTIES hp
1396: WHERE ica.case_number = cp_case_number
1397: AND ica.party_id = hp.party_id;
1398: BEGIN
1399: FOR cur IN l_party_csr(p_case_number) LOOP