APPS.OKL_DEAL_TERMS_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 1034: from OKL_PARTY_PAYMENT_HDR

1030: l_rgp_found VARCHAR2(1) := 'N';
1031:
1032: Cursor l_ppyh_csr (p_ppyh_id in number) is
1033: SELECT 'Y'
1034: from OKL_PARTY_PAYMENT_HDR
1035: where id = p_ppyh_id;
1036:
1037: l_ppyh_found VARCHAR2(1) := 'N';
1038:

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

1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: ElsIf l_rgp_found = 'N' then
1105: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for
1106: -- evergreen passthrough
1107: Open l_ppyh_csr (p_ppyh_id => p_tnc_id);
1108: Fetch l_ppyh_csr into l_ppyh_found;
1109: If l_ppyh_csr%NOTFOUND then