DBA Data[Home] [Help]

APPS.OZF_WEBADI_INTERFACE_PVT dependencies on OZF_CODE_CONVERSIONS_ALL

Line 105: FROM ozf_code_conversions_all

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

Line 157: FROM ozf_code_conversions_all

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

Line 208: FROM ozf_code_conversions_all

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