APPS.HZ_MIXNM_UTILITY dependencies on HZ_ORIG_SYSTEMS_B

Line 472: FROM hz_orig_systems_b

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

Line 965: FROM hz_orig_systems_b

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

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

2911: *
2912: * 03-01-2002 Jianying Huang o Created.
2913: * 12-31-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
2914: * content_source_type is foreign key to orig_system
2915: * in hz_orig_systems_b with sst_flag = 'Y'.
2916: */
2917:
2918: FUNCTION FindDataSource (
2919: p_content_source_type IN VARCHAR2,

Line 2933: FROM hz_orig_systems_b

2929:
2930: -- SSM SST Integration and Extension
2931: CURSOR c_valid_content_source_type (p_content_source_type IN VARCHAR2) IS
2932: SELECT '1'
2933: FROM hz_orig_systems_b
2934: WHERE orig_system = p_content_source_type
2935: AND sst_flag = 'Y'
2936: AND status = 'A';
2937: l_exists VARCHAR2(1) := 'N';

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

2976: IF l_final_data_source <> p_def_actual_content_source THEN
2977:
2978: /* SSM SST Integration and Extension
2979: * Lookup content_source_type is obsoleted.
2980: * Instead, all content_source_types should be valid orig_systems in HZ_ORIG_SYSTEMS_B
2981: * with sst_flag = 'Y'.
2982:
2983: HZ_UTILITY_V2PUB.validate_lookup (
2984: p_column => x_data_source_from,