APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 2283: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code

2279: , cv_start_date_active DATE
2280: , cv_end_date_active DATE
2281: , cv_conv_id NUMBER := -1)
2282: IS
2283: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code
2284: and code_conversion_id <> cv_conv_id
2285: and supp_trade_profile_id = cv_supp_trade_profile_id
2286: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between
2287: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 2291: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code

2287: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))
2288: or nvl(to_date(cv_end_date_active,'dd-mm-yyyy'),to_Date('31-12-9999','dd-mm-yyyy')) between
2289: 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')))
2290: union
2291: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code
2292: and code_conversion_id <> cv_conv_id
2293: and supp_trade_profile_id = cv_supp_trade_profile_id
2294: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between to_date(start_date_active,'dd-mm-yyyy')
2295: and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 3019: FROM ozf_supp_code_conversions_all

3015: attribute13,
3016: attribute14,
3017: attribute15,
3018: security_group_id
3019: FROM ozf_supp_code_conversions_all
3020: WHERE code_conversion_id = cv_code_conversion_id;
3021:
3022: CURSOR get_org
3023: IS