APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_BUS_OBJ_DEFINITIONS

Line 4022: FROM hz_bus_obj_definitions d

4018: ) IS
4019: CURSOR get_bus_obj(l_bus_obj VARCHAR2) IS
4020: SELECT d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4021: d.user_mandated_flag, d.root_node_flag, d.entity_name
4022: FROM hz_bus_obj_definitions d
4023: start with d.business_object_code = l_bus_obj and d.user_mandated_flag = 'Y'
4024: connect by prior d.child_bo_code = d.business_object_code and d.user_mandated_flag = 'Y'
4025: group by d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4026: d.user_mandated_flag, d.root_node_flag, d.entity_name;

Line 4078: FROM hz_bus_obj_definitions d

4074: l_telex VARCHAR2, l_web VARCHAR2, l_edi VARCHAR2,
4075: l_eft VARCHAR2, l_sms VARCHAR2) IS
4076: SELECT d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4077: d.user_mandated_flag, d.root_node_flag, d.entity_name
4078: FROM hz_bus_obj_definitions d
4079: start with d.business_object_code in (l_phone, l_email, l_telex, l_web, l_edi, l_eft, l_sms) and d.user_mandated_flag = 'Y'
4080: connect by prior d.child_bo_code = d.business_object_code
4081: and d.user_mandated_flag = 'Y'
4082: group by d.business_object_code, d.child_bo_code, d.tca_mandated_flag,