APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 2252: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code

2248: , cv_start_date_active DATE
2249: , cv_end_date_active DATE
2250: , cv_conv_id NUMBER := -1)
2251: IS
2252: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code
2253: and code_conversion_id <> cv_conv_id
2254: and supp_trade_profile_id = cv_supp_trade_profile_id
2255: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between
2256: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 2260: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code

2256: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))
2257: or nvl(to_date(cv_end_date_active,'dd-mm-yyyy'),to_Date('31-12-9999','dd-mm-yyyy')) between
2258: to_date(start_date_Active,'dd-mm-yyyy') and nvl(to_date(end_date_active,'dd-mm-yyyy'),to_Date('31-12-9999','dd-mm-yyyy')))
2259: union
2260: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code
2261: and code_conversion_id <> cv_conv_id
2262: and supp_trade_profile_id = cv_supp_trade_profile_id
2263: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between to_date(start_date_active,'dd-mm-yyyy')
2264: and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 2988: FROM ozf_supp_code_conversions_all

2984: attribute13,
2985: attribute14,
2986: attribute15,
2987: security_group_id
2988: FROM ozf_supp_code_conversions_all
2989: WHERE code_conversion_id = cv_code_conversion_id;
2990:
2991: CURSOR get_org
2992: IS