APPS.HZ_UTILITY_V2PUB dependencies on HZ_ORIG_SYSTEMS_B

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

2788: * FUNCTION is_purchased_content_source
2789: *
2790: * DESCRIPTION
2791: * This function will return 'Y' if the source system is a purchased one.
2792: * (i.e HZ_ORIG_SYSTEMS_B.orig_system_type = 'PURCHASED')
2793: *
2794: * ARGUMENTS
2795: * IN:
2796: * p_content_source

Line 2813: FROM HZ_ORIG_SYSTEMS_B

2809: ) RETURN VARCHAR2 IS
2810:
2811: CURSOR c_content_source IS
2812: SELECT 'Y'
2813: FROM HZ_ORIG_SYSTEMS_B
2814: WHERE orig_system = p_content_source
2815: AND orig_system_type = 'PURCHASED'
2816: -- AND status = 'A'
2817: AND rownum = 1;