APPS.OKL_DEAL_TERMS_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 1112: from OKL_PARTY_PAYMENT_HDR

1108: l_rgp_found VARCHAR2(1) := 'N';
1109:
1110: Cursor l_ppyh_csr (p_ppyh_id in number) is
1111: SELECT 'Y'
1112: from OKL_PARTY_PAYMENT_HDR
1113: where id = p_ppyh_id;
1114:
1115: l_ppyh_found VARCHAR2(1) := 'N';
1116:

Line 1183: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for

1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_ERROR;
1181: END IF;
1182: ElsIf l_rgp_found = 'N' then
1183: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for
1184: -- evergreen passthrough
1185: Open l_ppyh_csr (p_ppyh_id => p_tnc_id);
1186: Fetch l_ppyh_csr into l_ppyh_found;
1187: If l_ppyh_csr%NOTFOUND then