101: attribute14,
102: attribute15,
103: security_group_id,
104: org_id
105: FROM ozf_code_conversions_all
106: WHERE external_code = cv_external_code
107: AND org_id = NVL(cv_org_id,0) -- Bug#12559121
108: AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
109: AND party_id = cv_party_id
153: attribute14,
154: attribute15,
155: security_group_id,
156: org_id
157: FROM ozf_code_conversions_all
158: WHERE external_code = cv_external_code
159: AND org_id = NVL(cv_org_id,0) -- Bug#12559121
160: AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
161: AND party_id = cv_party_id
204: attribute14,
205: attribute15,
206: security_group_id,
207: org_id
208: FROM ozf_code_conversions_all
209: WHERE external_code = cv_external_code
210: AND org_id = NVL(cv_org_id,0) -- Bug#12559121
211: AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
212: AND TRUNC(cv_start_date_active) BETWEEN start_date_active and NVL(end_date_active,TRUNC(SYSDATE)) -- Bugfix 11822771