APPS.HZ_UTILITY_V2PUB dependencies on HZ_ORIG_SYSTEMS_B

Line 2776: * (i.e HZ_ORIG_SYSTEMS_B.orig_system_type = 'PURCHASED')

2772: * FUNCTION is_purchased_content_source
2773: *
2774: * DESCRIPTION
2775: * This function will return 'Y' if the source system is a purchased one.
2776: * (i.e HZ_ORIG_SYSTEMS_B.orig_system_type = 'PURCHASED')
2777: *
2778: * ARGUMENTS
2779: * IN:
2780: * p_content_source

Line 2797: FROM HZ_ORIG_SYSTEMS_B

2793: ) RETURN VARCHAR2 IS
2794:
2795: CURSOR c_content_source IS
2796: SELECT 'Y'
2797: FROM HZ_ORIG_SYSTEMS_B
2798: WHERE orig_system = p_content_source
2799: AND orig_system_type = 'PURCHASED'
2800: -- AND status = 'A'
2801: AND rownum = 1;