APPS.HZ_MIXNM_UTILITY dependencies on HZ_ORIG_SYSTEMS_B

Line 469: FROM hz_orig_systems_b

465: -- All valid content source types will be stored in PL/SQL tables for faster access.
466: CURSOR c_orig_systems
467: IS
468: SELECT orig_system
469: FROM hz_orig_systems_b
470: WHERE sst_flag = 'Y'
471: -- AND status = 'A'
472: ORDER BY orig_system;
473:

Line 962: FROM hz_orig_systems_b

958: -- All valid content source types will be stored in PL/SQL tables for faster access.
959: CURSOR c_orig_systems
960: IS
961: SELECT orig_system
962: FROM hz_orig_systems_b
963: WHERE sst_flag = 'Y'
964: -- AND status = 'A'
965: ORDER BY orig_system;
966:

Line 2905: * in hz_orig_systems_b with sst_flag = 'Y'.

2901: *
2902: * 03-01-2002 Jianying Huang o Created.
2903: * 12-31-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
2904: * content_source_type is foreign key to orig_system
2905: * in hz_orig_systems_b with sst_flag = 'Y'.
2906: */
2907:
2908: FUNCTION FindDataSource (
2909: p_content_source_type IN VARCHAR2,

Line 2923: FROM hz_orig_systems_b

2919:
2920: -- SSM SST Integration and Extension
2921: CURSOR c_valid_content_source_type (p_content_source_type IN VARCHAR2) IS
2922: SELECT '1'
2923: FROM hz_orig_systems_b
2924: WHERE orig_system = p_content_source_type
2925: AND sst_flag = 'Y'
2926: AND status = 'A';
2927: l_exists VARCHAR2(1) := 'N';

Line 2970: * Instead, all content_source_types should be valid orig_systems in HZ_ORIG_SYSTEMS_B

2966: IF l_final_data_source <> p_def_actual_content_source THEN
2967:
2968: /* SSM SST Integration and Extension
2969: * Lookup content_source_type is obsoleted.
2970: * Instead, all content_source_types should be valid orig_systems in HZ_ORIG_SYSTEMS_B
2971: * with sst_flag = 'Y'.
2972:
2973: HZ_UTILITY_V2PUB.validate_lookup (
2974: p_column => x_data_source_from,